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 “digester” 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
digester1025843(None) 
diester83013681di_ester
digested11208161digested
digesters11257881digesters
digestor10246551digestor
bimester1236162bimester
detester9239682detester
diaster82813312di_aster
diesters92513602di_esters
dieter73516772di_e_ter
digest84019622digest__
digestif1396172digestif
digestors11257272digestors
digests93610612digest_s
dimeter10411892dime_ter
directer1137582directer
disaster949942disaster
diverter12238622diverter
divested13268212divested
dopester1137252dopester
figeater1236952figeater
kiester11329972ki_ester
rimester1037812rimester
arrester839253arrester
attester836503attester
auguster943953auguster
begetter11136313begetter
bimesters1336343bimesters
bister84922763bi__ster
dabster1036703d_abster
decenter112412163decenter
deemster1175713deemster
defeater122611663defeater
defter104215923d__efter
degasser10325813degasser
degender1136893degender
degusted1135733degusted
deluster936903deluster
demister11310223demister
dempster1355773dempster
deserter91211603deserter
detecter11298733detecter
deter65028043d__e_ter
detested10279623detested
detesters10298303detesters
devested13239133devested
dexter143810893d__exter
diameter1148053diameter
diastem10318043di_astem
diasters92913183di_asters
diesel74410403di_es_el
dieses75218693di_es_es
dieted83115493di_e_ted
dieters83216433di_e_ters
diether1147443di_ether
digestifs1484433digestifs
digesting12208673digesting
digestion1146573digestion
digestive1446243digestive
digestives1545213digestives
digger94616083dig__ger
dighted132511493dig_hted
digressed1245613digressed
digresses1137863digresses
dilater83515653di_later
diluter8319663di_luter
dimeters11411093dime_ters
dinette8310013dinette_
dinettes9310193dinettes
diopter1038473di_opter
directed1238233directed
director1147783director
direst75024243direst__
disasters1039153disasters
disesteem1244623disesteem
disgusted1246123disgusted
disinter9310673disinter
disputer1137973disputer
dissenter1059133dissenter
dissever12107653dissever
ditsier83010293di_tsier
diverted13199583diverted
diverters13227873diverters
divest106820073divest__
divests114510933divest_s
divesture13144183divesture
doomster1135843doomster
dopesters1237283dopesters
dragster1034623dragster
dresser83611953d_resser
dumpster1344053dumpster
duster74919723d__uster
egested938123_egested
ester54727713___ester
fester94723513__fester
fibster12146533fi_bster
fidgeter1343783fidge_ter
figeaters1345753figeaters
fighter143010773fig_hter
filister1137403filister
forester11313673forester
gagster9317633gag_ster
gamester1137323gamester
gaster75027353__gaster
geste65920693__geste_
gestes75721393__gestes
getter74117613__getter
hipster12288783hi_pster
honester1139713honester
igniter8147673_igniter
indigested13103673indigested
infester11239433infester
ingested10259003ingested
jester134319153__jester
jokester1934443jokester
keester11319913_keester
kiesters123310153ki_esters
lighter113113443lig_hter
lister64527253li__ster
magister1136283magister
minister10410363minister
minster93914323mi_nster
misenter10310833misenter
mister84728563mi__ster
modester1197483modester
molester1099373molester
nester64124183__nester
pester84827593__pester
piaster93012883pi_aster
pilaster1038163pilaster
pinaster1037113pinaster
pipestem1443743pipestem
prester93519623_prester
quester161410023_quester
redigested1354113redigested
register939553register
rester63832433__rester
righter113212383rig_hter
rimesters1137483rimesters
riveter10208753rive_ter
semester1038903semester
sidestep1144243sidestep
sighter113412113sig_hter
silenter838873silenter
sinister838583sinister
sister64421583si__ster
suggester1143733suggester
tester64227153__tester
tighter112910693tig_hter
tipster9299053ti_pster
trimester1145823trimester
undigested13123843undigested
vignetter1343323vignetter
wester94222893__wester
wrester102812413_wrester
yester93417983__yester
zester153617793__zester

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621576.76621602.4
3Display Results1571570.0602616.7
 (SQL Overall)1786911577.24924650.4
 
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.