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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
thuggee124526(None) 
thuggees1343121thuggees
chugged1584822chugged
chugger1445372chugger
hugged124113642_hugged
hugger114713122_hugger
muggee103612832_muggee
thuggery1642562thuggery
tugged93813522t_ugged
tugger84013102t_ugger
bugged114318403_bugged
bugger104418723_bugger
bungee96319773_bungee
burgee97120593_burgee
chigger1436003chigger
chuggers1554863chuggers
chutnee1246833chutnee
drugged11367183drugged
drugget10337613drugget
druggie10134073druggie
frugged13387293frugged
fugged124615383_fugged
glugged11396623glugged
guggle94110433_guggle
hagged124317703_hagged
haggle113511983_haggle
higgle113811743_higgle
hogged125817773_hogged
hogger114615083_hogger
hogget114715763_hogget
huge86321653_hu_g_e
huger94914873_hu_ger
huggers124211593_huggers
humvee1439203_humvee
hunger104015203_hunger
jugged163813933_jugged
juggle154310283_juggle
lugged94417063_lugged
lugger83916553_lugger
luggie8318903_luggie
lungee75119813_lungee
mugged114113833_mugged
muggees11338883_muggees
mugger103914703_mugger
nugget8311723_nugget
plugged12408043plugged
plugger11378433plugger
pugged114314533_pugged
puggree11176113_puggree
pugree92112473_pugree
raggee84217603_raggee
rugged94215383_rugged
rugger84414513_rugger
shagged134210133shagged
shogged13397963shogged
shrugged1433673shrugged
slugged104410383slugged
slugger93610683slugger
smugger11327053smugger
smuggle11265013smuggle
snugged10408033snugged
snugger9318313snugger
snuggle9275713snuggle
struggle10345053struggle
tagged93418123t_agged
tagger84017703t_agger
thee78039063th___ee
thighed1535273thighed
thonged12376843thonged
three87526913th__ree
thudded1333433thudded
thug86415483thu_g__
thuggeries1543373thuggeries
thuggish1642653thuggish
thugs95611993thu_g_s
thumbed15336173thumbed
thumped15387413thumped
thumper14356953thumper
thunder1136963thunder
thunked15386853thunked
togged95117513t_ogged
toggle83810873t_oggle
toughed123511693toughed
toughen11329203toughen
tougher114210983tougher
toughie1187593toughie
toupee8316133tou_pee
trigged10359853trigged
trigger9329163trigger
trudge8318733trudg_e
trudged10298043trudged
trudgen9357053trudgen
trudger9338733trudger
trudges9339993trudges
trustee73514443trustee
tuggers93711443t_uggers
tutee5423523t_u_tee
twigged13345283twigged
twiggen12333503twiggen
whangee14268613whangee

Search took 7 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.406440125.6
2DLD Change Limit1340271006.29621287.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.73226543.5
 
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.