Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “weest” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
weest8502677(None) 
geest64829611geest
reest54938091reest
wees76249121wees_
weet75254151wee_t
weets85427721weets
west75748081w_est
wrest84925431wrest
beast76338642beast
bees65453382bees_
beet66457542bee_t
beets76131442beets
behest11314612behest
beset76739132beset
best66355322_best
blest76431722blest
cees65941592cees_
chest104926142chest
crest74632692crest
dees56356632dees_
deet57356582dee_t
deets65330242deets
deist64633592deist
detest74122842detest
devest104418702devest
doest65829522doest
drest65530342drest
east46659102_east
egest65222342egest
erst47436432_erst
ewes76328702ewes_
feast85932722feast
fees76450602fees_
feet75352212fee_t
feist86230072feist
fest74949442_fest
fewest12311662fewest
feyest12311402feyest
freest95318282freest
gees55647882gees_
geese64316002geese
geests75912162geests
gest56149132_gest
guest65225922guest
heist87030912heist
hest75950772_hest
jees115938542jees_
jest116738502_jest
keet85347342kee_t
keets95123482keets
least56134882least
lees45455882lees_
leet45957902lee_t
leets54927122leets
lest46956322_lest
meet65350552mee_t
meets74224612meets
merest84725112merest
neist54628442neist
nest45548732_nest
newest9314212newest
pees65257372pees_
pest65555292_pest
prest75736352prest
quest144121322quest
rees45364192rees_
reests64618892reests
renest64529712renest
reset55051862reset
rest46459842_rest
retest64028452retest
revest94623602revest
sees45361052sees_
serest64831612serest
sweet85330522swee_t
sweets94214432sweets
tees45353582tees_
test48651622_test
tweet84823982twee_t
tweets94210102tweets
vees75439432vees_
verst84429372verst
vest75743602_vest
waes76048602waes_
waist86132382waist
wast75655852w_ast
weakest1439002weakest
webs96622122webs_
wecht13415442wecht
weds86628932weds_
wee66760812wee__
weed85637512wee_d
weeds95222212weeds
weedy125115002weedy
week116428152wee_k
weeks125017862weeks
weel75834082wee_l
ween75835462wee_n
weens85224052weens
weensy12416822weensy
weeny115316162weeny
weep95131652wee_p
weeps104120562weeps
weepy134212592weepy
weer75535092wee_r
weft105435012w_eft
wefts116715492wefts
welsh113110362welsh
welt75547862w_elt
welts85225192welts
wens76337932wens_
went76051872w_ent
wept95635052w_ept
wert79749822w_ert
wests85727002w_ests
wet65966622w_e_t
wets75940292wets_
wettest10239362wettest
wheat114924572wheat
whet105133782whe_t
whets115019612whets
whist115322952whist
widest104517002widest
wisest95016442wisest
wist78049292w_ist
woes76440662woes_
worst86330132worst
wost76544362w_ost
wrests95313082wrests
wriest94419712wriest
wrist84827562wrist
wryest12429112wryest
wurst85122992wurst
wyes105727502wyes_
yeast85327942yeast
zees136331892zees_
zest136035702_zest

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.330541487.9
2DLD Change Limit538001371.36039558.8
3Display Results1371370.0462978.3
 (SQL Overall)1786911371.736102932.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.