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 “sheughs” with Change Limit: [1] [2] [3]

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

150 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
sheughs1426453(None) 
heughs13516901_heughs
shaughs14245281shaughs
sheuchs15234931sheuchs
sheugh13295881sheugh_
choughs16576622choughs
haughs13408562_haughs
heuchs14447922_heuchs
heugh125410922_heugh_
saughs104812052s_aughs
shaugh13287432shaugh_
sheaths1358742sheaths
sheikhs17233992sheikhs
sheuch14267042sheuch_
shrugs10469162shrug_s
sleighs11245672sleighs
sleuths1034742sleuths
sloughs11497562sloughs
soughs105115622s_oughs
sughs95313322s__ughs
boughs125414373_boughs
brughs12509063_brughs
chetahs15347073chetahs
cheths14389823che_ths
chough15699243chough_
chugs115511943ch_ug_s
cloughs13517053cloughs
coughs125514543_coughs
doughs115912933_doughs
enoughs1144623enoughs
haugh125114053_haugh_
heaths126316383_heaths
hedges115016243_hedges
hehs106723963_he__hs
heigh124812543_heigh_
height134713433_height
heights14399443_heights
henges104516453_henges
heths116317783_he_ths
heuch135312333_heuch_
highs125412523_h_ighs
hugs86129753_h_ug_s
khedahs1852953khedahs
kheths16495973khe_ths
kiaughs1542283kiaughs
laughs10489023_laughs
loughs105014773_loughs
neighs10387733_neighs
ploughs13526103ploughs
rheums1135463rheu_ms
roughs105416213_roughs
sanghs105312063s_anghs
sauchs115112233s_auchs
saugh95318403s_augh_
saughy13507463s_aughy
scouths12527893scouths
sedges83817793s_edges
segos64919483s_e_gos
segs54933883s_e_g_s
segues7412073s_egues
selahs9313213s_elahs
serges74225963s_erges
shags95123863sh_ag_s
shahs115919513sh__ahs
shauls94913113shau_ls
sheafs124912883she_afs
sheals94420643she_als
shears93820903she_ars
sheas86331793she__as
sheath12412883sheath_
sheathe1348983sheathe
sheathes14610183sheathes
sheaves134412973sheaves
sheds96122703she__ds
sheens95116993she_ens
sheers94322403she_ers
sheesh1237813sheesh_
sheets93918493she_ets
sheeves133911953sheeves
sheikh16206993sheikh_
sheiks132510013she_iks
sheilas1059403sheilas
shekels1436043shekels
shells94319523she_lls
sheltas10279663sheltas
shelves134112093shelves
shends105313773she_nds
sheols94614153she_ols
sheqels1934753sheqels
sherds105614723she_rds
sherifs13299683sherifs
sherpas1238093sherpas
sherris10168793sherris
shes75734353she___s
shewers134312043shewers
shews115924713she__ws
shibahs15275643shibahs
shivahs16375723shivahs
shlubs11386733shlu_bs
shlumps1434143shlumps
shmucks1833943shmucks
shogis103810933sh_ogis
shogs95319703sh_og_s
shoguns1134413shoguns
shouts94017713shou_ts
shrubs11409213shru_bs
shrug94512513shrug__
shucks154010413sh_ucks
shuls85319713sh_u_ls
shuns85018143sh_u_ns
shunts95712013sh_unts
shush113812543sh_ush_
shushes133510303sh_ushes
shutes93518213sh_utes
shuts85622473sh_u_ts
sieges73816833sie_ges
sieurs659043sieu_rs
sighs95416743s__ighs
skegs105011233ske_g_s
skeigh14265903skeigh_
skreeghs16212103skreeghs
skreighs16203153skreighs
sledges94511553sledges
sleigh10258203sleigh_
sleight11279023sleight
sleights12275913sleights
sleuth937233sleuth_
slough10539233slough_
sloughy14535803sloughy
slugs64618563s_lug_s
snugs64913023s_nug_s
sough95320463s_ough_
sought106315053s_ought
souths95216603s_ouths
sprugs94010173sprug_s
squegs1675643squeg_s
stengahs1243393stengahs
sugh86423443s__ugh_
teugh95511613_teugh_
thegns10547433the_gns
thighs1346633th_ighs
though139410773though_
thought14639133thought
thoughts15515603thoughts
thugs95611993th_ug_s
toughs105414983_toughs
troughs11698683troughs
ughs85410973___ughs
vughs12678743__vughs
weighs13338873_weighs

Search took 10 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271508.91015042.3
3Display Results1501500.0463260.9
 (SQL Overall)1786911509.09619645.0
 
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.