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

226 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
deluster93690(None) 
delusters1035971delusters
baluster1037052baluster
bluster94215312_bluster
cluster94013322_cluster
deemster1175712deemster
defuser115110502defus_er
degusted1135732degusted
delisted10310562delisted
delouser936362delous_er
deluder9168332delu_der
delustered1243292delustered
demister11310222demister
dempster1355772dempster
detester9239682detester
diluter8319652dilu_ter
duster74919722d__uster
fluster103913062_fluster
luster64023672__luster
adjuster1644343adjuster
aflutter1163813aflutter
auguster943943auguster
balusters1136633balusters
belter84720963bel__ter
blaster94017303_blaster
blister94415313_blister
blunter94512033_blunter
blurter9419833_blurter
blusher124113113_blusher
blusters104413883_blusters
blustery13368003_blustery
bolster93713423bol_ster
buster84726493__buster
celeste949653celeste_
celestes10310013celestes
clusters102912393_clusters
clustery13317103_clustery
clutter94211653_clutter
clyster12317453_clyster
dabster1036703d_abster
daunter83811753d_aunter
debaser103510413debas_er
debater104114693de_bater
debugger1343123debugger
debunker1543093debunker
debuted11379333debu_ted
decanter112510793decanter
decenter112412163decenter
deducted1356243deducted
deemsters1285023deemsters
defaulter1343133defaulter
defeater122611663defeater
deflater123211603deflater
defroster1343893defroster
defter104215923de__fter
defuse105712723defus_e_
defused125211093defus_ed
defusers12487363defus_ers
defuses114814593defus_es
degasser10325813degasser
degausser1172163degausser
degust8310253degust__
degusts936063degust_s
delate73827753del_ate_
delated93722873del_ated
delates83526283del_ates
delator83015023del_ator
delayer113010533del_ayer
delete73620703del_ete_
deleted93314903del_eted
deletes83117933del_etes
delighter1445583delighter
delimiter1246243delimiter
delist74625053delist__
delists84414173delist_s
deliver113312243del_iver
delouse839833delous_e_
deloused1036973delous_ed
delousers1044663delous_ers
delouses9310013delous_es
delude81910673delu_de_
deluded10158763delu_ded
deluders10156433delu_ders
deludes91810643delu_des
deluge8189403delu_ge_
deluged10167413delu_ged
deluges9169263delu_ges
delusion937433delusion
delusive1245843delusive
delusory1273003delusory
delustering1344073delustering
deluxe14197303delu_xe_
delver104913493del__ver
demasted1238763demasted
demisters1249203demisters
dempsters1435273dempsters
demurer1037873demu_rer
demurrer1144043demurrer
denser74115193de_ns_er
denuder9167603denu_der
depicter1356853depicter
depleter11298853depleter
deporter1169393deporter
deposer104011843depos_er
depute94512303depu_te_
deputed114610173depu_ted
deputes104911783depu_tes
desalter938363desalter
deserter91211603deserter
desisted1039783desisted
detecter11298733detecter
deter65028043de___ter
detested10279623detested
detesters10298303detesters
devested13239133devested
deviser114212393devis_er
devouter1235513devouter
dewater112912423de_water
dexter143810893de__xter
diaster82813313d_iaster
diester83013683d_iester
digester10258423digester
dilater83515643dil_ater
dilute72911803dilu_te_
diluted9248933dilu_ted
diluters9288103dilu_ters
dilutes82911963dilu_tes
dilutor8256013dilu_tor
disaster949943disaster
doomster1135843doomster
dopester1137253dopester
doubter10298353d_oubter
douser75621633d_ous_er
dragster1034623dragster
dumpster1344053dumpster
dusted83918373d__usted
dusters84918353d__usters
dustier83814133d__ustier
easter65027983_e_aster
elater64724203_el_ater
eluate62315433_eluate_
eluates72014673_eluates
eluder73712213_elu_der
elute54822573_elu_te_
eluted74915263_elu_ted
elutes64020313_elu_tes
enlister847803enlister
ester54727713_e__ster
feaster10812983fe_aster
feldsher1543243feldsher
fester94723513fe__ster
filister1137403filister
flusher133012273_flusher
flusters113811493_flusters
fluter95316863_flu_ter
flutter104012093_flutter
glister84013343_glister
heister103613623he_ister
holster103512213hol_ster
jester134319153je__ster
jouster143311043_jouster
juster134617013__juster
keester11319913ke_ester
keister113011573ke_ister
kelter103214373kel__ter
keyster14256153ke_yster
klister113410643_klister
laster64830633__laster
leister73212753le_ister
lister64527253__lister
lusher93818763__lusher
lusted74319443__lusted
lusters73921433__lusters
lustier73813503__lustier
lustre64011683__lustre
maltster1035303maltster
meister93114163me_ister
melter83520113mel__ter
molester1099373molester
muster84724523__muster
nester64124183ne__ster
neuter63713793ne_u_ter
oldster896573_oldster
oleaster837263oleaster
ouster64223733__ouster
pelter83321623pel__ter
penster92811953pe_nster
peruser93511373perus_er
pester84827593pe__ster
pilaster1038163pilaster
plaster93318693_plaster
plusher124010383_plusher
pollster1037103pollster
rebutter10106273rebutter
refuser104912783refus_er
refuter104312193refu_ter
register939553register
relater73723143rel_ater
reletter81311023reletter
relisted9312623relisted
relucted1138653relucted
remaster10311473remaster
replaster1136583replaster
requester1855513requester
requiter17168643requiter
resister8311653resister
rester63832433re__ster
reutter71010093re_utter
robuster1035663robuster
rouster73517083_rouster
saluter73512453salu_ter
seamster1037143seamster
semester1038903semester
sequester1844443sequester
splutter10357443splutter
teamster1036293teamster
tester64227153te__ster
thruster1135793thruster
truster73114313_truster
ulster63712103_ul_ster
webster1236093we_bster
welsher13377443wel_sher
welter93417383wel__ter
wester94222893we__ster
yester93417983ye__ster
zester153617793ze__ster

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622269.15615963.5
3Display Results2262260.0932430.1
 (SQL Overall)1786912269.40518999.6
 
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.