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

157 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
drugget1033761(None) 
drugged11367171drugged
druggets11313911druggets
dragged11379562dragged
dragger10309172dragger
dragnet91211432dragnet
drudge9317902drudge_
drudged11277612drudged
drudger10328322drudger
drudges10308872drudges
druggie10134072druggie
druggier11134832druggier
druggies11126222druggies
druggiest12134972druggiest
druggist11163662druggist
druggy12344742drugg_y
frugged13387282frugged
nugget8311722_nugget
rugged94215372_rugged
rugger84414512_rugger
bedrugged1542303bedrugged
bragged12449843bragged
bragger113810043bragger
braggest1296533braggest
brunet84419293bru_net
budget104618113_budget
bugged114318403_bugged
bugger104418723_bugger
chugged1584823chugged
chugger1445373chugger
cragged12479883cragged
cruet74831843cru__et
crumpet133711063crumpet
cruset84425093cru_set
dagger95017303d_agger
debugged1433223debugged
debugger1343123debugger
digged104314653d_igged
digger94616083d_igger
dogged106017703d_ogged
dogger95216783d_ogger
doublet103914033doublet
dought114915513dou_ght
drabbet12319573drabbet
dragee84415603dr_agee
dragees9359483dragees
draggers11357393draggers
draggier11135773draggier
draggiest12126413draggiest
draggle1056103draggle
draggled1254673draggled
draggles1145963draggles
draggy12346823dragg_y
dragnets10136563dragnets
dragonet10138953dragonet
draught12266963draught
dredge9308553dredge_
dredged11346883dredged
dredger10347443dredger
dredges10379343dredges
dreggier1193553dreggier
dreggiest12124543dreggiest
dreggy12364633dregg_y
driblet103712243driblet
drogue8938333drogue_
drogues9398393drogues
droplet10312113droplet
drought12258873drought
drubbed13406983drubbed
drubber12357863drubber
drudgers11326853drudgers
drudgery14273633drudgery
drug65718133dru_g__
drugging12326443drugging
druggists12112133druggists
drugs75214653dru_g_s
drumbeat1343973drumbeat
drummed13306323drummed
drummer12407503drummer
drunken12263713drunken
drunker12326633drunker
drunkest1334423drunkest
drupe85012993dru_pe_
drupelet1145663drupelet
drupes94912653dru_pes
druse64817663dru_se_
druses75517253dru_ses
duet56446263d_u__et
dugout8310363d_ugout
dulcet9314493d_ulcet
dunged95414693d_unged
duvet9321873d_u_vet
fragged134010163fragged
frigged13439053frigged
frogged13408493frogged
froglet11310063froglet
fugged124615383_fugged
glugged11396613glugged
grudge9388583grudge_
grudged11317163grudged
grudger10368313grudger
grudges10349423grudges
grummet12298873grummet
grunge8359583grunge_
grunger9389783grunger
grunges93310403grunges
guglet84018223_guglet
gurglet94412033gurglet
hogget114715763_hogget
hugged124113643_hugged
hugger114713123_hugger
jugged163813933_jugged
lugged94417053_lugged
lugger83916553_lugger
mugged114113833_mugged
muggee103612833_muggee
mugger103914703_mugger
nuggets936383_nuggets
nuggety1234313_nuggety
plugged12408033plugged
plugger11378423plugger
prigged12398923prigged
progged12409793progged
progger11319373progger
pugged114314523_pugged
ragged94620263_ragged
raggee84217603_raggee
reglet73724233_reglet
regret73723533_regret
rigged94517403_rigged
rigger85616713_rigger
rugae65114763_rugae_
rugate75813813_rugate
ruggers94612313_ruggers
runlet63821413_runlet
russet6319433_russet
shrugged1433663shrugged
slugged104410373slugged
slugger93610673slugger
smugger11327053smugger
smuggest1244373smuggest
snugged10408023snugged
snugger9318313snugger
snuggest1045233snuggest
suggest9310863_suggest
thuggee1245263thuggee
trigged10359853trigged
trigger9329163trigger
triggest1036923triggest
trudge8318733trudge_
trudged10298043trudged
trudgen9357053trudgen
trudger9338733trudger
trudges9339993trudges
trumpet113810723trumpet
tugged93813523_tugged
tugger84013103_tugger

Search took 9 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.296603685.8
2DLD Change Limit1340271578.08016587.5
3Display Results1571570.0463413.0
 (SQL Overall)1786911578.42221217.2
 
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.