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

121 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
rotguts83376(None) 
rotgut738791rotgut_
catguts1045322catguts
rogues74617672ro_gues
routs57133412ro__uts
bogus85616473bo_gu_s
botts75224863bot__ts
bouts75131313bo__uts
brogues10719823bro_gues
bututs8409423but_uts
catgut9310803catgut_
cobnuts1135353cobnuts
copouts11311083copouts
cutouts938033cutouts
donuts7410583do_nuts
drogues9398393dro_gues
dropouts1145003dropouts
droughts13245733droughts
foreguts1245563foreguts
forgets113813793forgets
gorgets94711783gorgets
gouts64826173go__uts
grouts75015613gro__uts
guts56637253___guts
hoggets12498323hoggets
hognuts1134183hognuts
loggats9286453loggats
loggets9378913loggets
lotus55718063lot_u_s
louts56330273lo__uts
midguts11296013midguts
moguls948553mo_guls
morgues1038273morgues
motets84216193mot_ets
motmots1166133motmots
motts76527003mot__ts
nougats8427413nougats
noughts11478083noughts
oughts104710183_oughts
outguns8318693outguns
outjuts1476493outjuts
outputs988493outputs
outs45746963_o__uts
popguns1234023popguns
potfuls1236293potfuls
pouts75530323po__uts
protects1239743protects
protests10310493protests
proteus92511593proteu_s
protists10313363protists
protiums1238553protiums
putouts937083putouts
ragouts838543ragouts
rebuts84015193r_ebuts
recuts83817373r_ecuts
redouts81411663redouts
retests73813853retests
retints74717013retints
retorts76016513retorts
rights104019333r_ights
riotous739863riotou_s
roasts64915413ro_asts
robots8313153ro_bots
robust8310433ro_bust
rochets124213473rochets
rockets134615363rockets
rodents8611543rodents
rogers74517913ro_gers
rogue66417533ro_gu_e
rogued84711473ro_gued
roguish1156833ro_guish
rollouts8136733rollouts
romaunts1043693romaunts
rontgens944683rontgens
roosts64916323ro_osts
rootlets8308653rootlets
roots55933673ro__ots
roques154912563ro_ques
roquets16398943roquets
rosets65819953ro_sets
rostrums1046083rostrums
rotas54827723rot__as
rotate63320343rot_ate
rotates72819773rotates
rotches123515703rotches
rotes56143903rot__es
rotis56327063rot__is
rotls55620163rot__ls
rotors64917953rot_ors
rotos56027883rot__os
rots46454093ro___ts
rotte54625933rot__te
rotters74421393rotters
rottes64524833rot_tes
rotund737293rot_und
roues56039353ro__ues
rouges76022383roug_es
roughs105416213roug_hs
roups75118903ro__ups
roust55532063ro__ust
rousts617016723ro_usts
rout46153283ro__ut_
route55132073ro__ute
routes66129313ro__utes
routh86423073ro__uth
rouths95416823ro__uths
rubouts937983rubouts
runouts737353runouts
ruts44541493r___uts
setouts74110333setouts
shotguns1242313shotguns
stouts65019003_stouts
struts65616803_struts
tauts56125513__tauts
togues76014243to_gues
tongues879693tongues
touts54830393__touts
trouts66116633tro__uts
tuts45838453__t_uts
vogues104011923vo_gues
yogurts1142983yo_gurts

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 Limit1340271216.45320769.7
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.90525878.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.