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 “waist” 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.

144 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
waist8613238(None) 
maist75535671maist
waists97415451waists
wait75553691wai_t
waits88333521waits
wast75655851wa_st
whist115322951whist
wist78049291w_ist
wrist84827561wrist
agist66325582agist
airt45757782_airt
ais39083572_ais_
ait38093902_ai_t
aits46355532_aits
alist56136782alist
await85524492awai_t
awaits96411952awaits
bait66556002bai_t
baits76630582baits
bast66362412ba_st
canst74932212canst
cast67159902ca_st
cist67244962_cist
dais57040702dais_
daisy95915312daisy
deist64633592deist
east46659102ea_st
exist124618942exist
faint85837062faint
fast77052312fa_st
feist86230072feist
fist76248422_fist
foist85730972foist
gainst74914692gainst
gait56150192gai_t
gaits65726012gaits
gast56052562ga_st
gist56046762_gist
grist65529872grist
hadst93220222hadst
haint85436322haint
hast76259482ha_st
heist87030912heist
hist76551542_hist
hoist86433212hoist
joist125125652joist
karst97228992karst
kist86540792_kist
last46260322la_st
list47055342_list
maists85817572maists
mast65959952ma_st
mayst106622672mayst
mist66154522_mist
moist76033572moist
neist54628442neist
oast47156322oa_st
odist6421912odist
paint75443692paint
paisa76021072paisa
paise75028332paise
papist102618742papist
past65959012pa_st
racist82822792racist
rais45252622rais_
raise54828052raise
rapist82520672rapist
sadist74221352sadist
saint55147072saint
sayst85322002sayst
shist84829602shist
taint55542282taint
tanist6324592tanist
twist86820982twist
vast75045122va_st
wabs97337232wabs_
wadis95223962wadis_
wads87343142wads_
wadset10314302wadset
waes76048602waes_
waft106139002wa_ft
wafts116920552wafts
wags86140552wags_
waif105836742wai_f
waifs115719872waifs
wail75238822wai_l
wails86631482wails
wain75840192wai_n
wains86930862wains
wair75830052wai_r
wairs86424062wairs
waisted114210942waisted
waister103812382waister
waive114214602waive
waniest103819112waniest
wans76452262wans_
want76156162wa_nt
wants87932212wants
waps96642082waps_
wariest105122502wariest
wars78659802wars_
wart77866082wa_rt
warts814840402warts
was68767562wa_s_
wash106033812wa_sh
wasp95626852wa_sp
waste86125052wa_ste
wasts87433672wa_sts
wat67378922wa__t
wats77555882wats_
watt75545412wa_tt
watts86923092watts
waviest134513072waviest
waws106834902waws_
waxiest173510882waxiest
ways107737952ways_
weest85026772weest
west75748082w_est
whilst1239142whilst
whipt135317422whipt
whish144512922whish
whisht154510812whisht
whisk154510142whisk
whists124613812whists
whit104834172whi_t
whits115923822whits
wilt76246292w_ilt
wis66552332w_is_
wise75737342w_ise
wish107228732w_ish
wisp97124072w_isp
wiss75630542w_iss
wists86728522w_ists
wit66563772w_i_t
wits76044872w_its
worst86330132worst
wost76544362w_ost
wrest84925432wrest
wriest94419712wriest
wrists95415642wrists
wristy12509702wristy
writ75537912wri_t
writs86624382writs
wurst85122992wurst

Search took 4 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.186960704.3
2DLD Change Limit538001443.25016553.8
3Display Results1441440.0334363.6
 (SQL Overall)1786911443.46951510.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.