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

252 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
demister1131022(None) 
demisters1249201demisters
dempster1355771dempster
bemisted1368382bemisted
deemster1175712deemster
delisted10310562delisted
deluster936902deluster
demasted1238762demasted
demise94618322demis_e_
demised113613682demis_ed
demises103719562demis_es
demitted12288772demitted
dempsters1435272dempsters
depicter1356852depicter
desisted1039782desisted
detester9239682detester
deviser114212392devis_er
dumpster1344052dumpster
emitter93211082_emitter
heister103613622he_ister
hemipter1545582hemipter
keister113011572ke_ister
lamister1037652lamister
leister73212752le_ister
meister93114162me_ister
mister84728562__mister
register939552register
remaster10311472remaster
remitter102810322remitter
resister8311652resister
semester1038902semester
admitter1135113admitter
assister836753assister
banister10199973banister
bemist105216953bemist__
bemists113410703bemist_s
bimester1236163bimester
bister84922763__bister
blemisher1663653blemisher
blister94415313_blister
canister101710853canister
cementer1239193cementer
cloister1037093cloister
dabster1036703d_abster
debaser103510413debas_er
debater104114693de_bater
debited113311623debi_ted
decanter112510793decanter
decenter112412163decenter
decider114213183deci_der
deciliter1247033deciliter
decimeter14147413decimeter
decipher1644423decipher
deemsters1285023deemsters
defeater122611663defeater
defier105118653defi__er
defiler113911883defi_ler
definer114413773defi_ner
deflater123211603deflater
defroster1343893defroster
defter104215923de__fter
defuser115110503defus_er
degasser10325813degasser
degusted1135733degusted
dehisce13104273dehisce_
dehisced1583683dehisced
dehisces1464713dehisces
deicer94114413de_i_cer
deifier113013123de_ifier
deist64633593de_ist__
deistic10311173de_istic
deists74916433de_ist_s
delighter1445583delighter
delimiter1246243delimiter
delist74625053delist__
delists84414173delist_s
deliver113312243deli_ver
delusters1035983delusters
demander12238723demander
demast9517063demast__
demasts1089223demast_s
demented12311273demented
demerger12127373demerger
demesne1035573demesne_
demesnes1137083demesnes
demies94825803demi__es
demirep1236213demi_rep
demising122012523demising
demit84832303demi_t__
demits94918073demi_t_s
demolisher1693643demolisher
demoses103815823demos_es
demote94817803dem_ote_
demoted114313543dem_oted
demotes104717673dem_otes
demurer1037873dem_urer
demurrer1144043demurrer
denier74420693deni__er
denser74115193de_ns_er
depicted1437743depicted
depicters1435823depicters
depictor1355513depictor
depleter11298863depleter
deporter1169393deporter
deposer104011843depos_er
derider93214973deri_der
deringer1038143deringer
deriver114213913deri_ver
dermises112512023dermis_es
desalter938363desalter
deserter91211603deserter
designer1036543designer
desilver12286503desilver
desirer8310783desi_rer
desist74818813desist__
desists83611723desist_s
despiser1136343despis_er
detecter11298733detecter
deter65028043de___ter
detested10279623detested
detesters10298303detesters
deticker1545283deticker
devested13239133devested
deviate11312713deviate_
deviated13311043deviated
deviates12312733deviates
deviator1248313deviator
devise104215753devis_e_
devised123712563devis_ed
devisee113812713devis_ee
devisees12358283devisees
devisers12339863devis_ers
devises114116763devis_es
devisor11357043devis_or
devouter1235513devouter
dewater112912423de_water
dewier104013463dewi__er
dexter143810893de__xter
diaster82813313d_iaster
diester83013683d_iester
dieter73516773d__ieter
digester10258433digester
dimeter10411893dim_eter
disaster949943disaster
disinter9310673disinter
domineer1146273domineer
doomster1135843doomster
dopester1137253dopester
dragster1034623dragster
drifter11348703d_rifter
dumpsters1453743dumpsters
duster74919723d__uster
easter65027983_e_aster
embitter12245623_embitter
emitted103010853_emitted
emitters10349643_emitters
emoter85415193_em_oter
enlister847803enlister
epistler1044833_epistler
ester54727713_e__ster
existed1538473_existed
feaster10812983fe_aster
feistier1136193fe_istier
fester94723513fe__ster
filister1137403filister
gamester1137323gamester
ganister9178993ganister
glister84013343_glister
grister83915413_grister
hamster12810423ham_ster
heisted113210653he_isted
heisters113413133he_isters
hemipters1645683hemipters
hoister103714203_hoister
insister888783insister
jester134319153je__ster
keester11319913ke_ester
keisters123212043ke_isters
keyster14256153ke_yster
klister113410643_klister
lamisters1157123lamisters
lamster9109913lam_ster
leisters83312823le_isters
limiter92710853limi_ter
lister64527253__lister
magister1136283magister
master84831343__master
meisters103313843me_isters
meristem1245743meristem
milter84921233__milter
minister10410363minister
minster93914323__minster
minter84425103__minter
miser75430403__mis_er
misted93625823__misted
misterm114314513__misterm
misters93927513__misters
mistier93418713__mistier
miter75734793__mi_ter
moister94015373_moister
muster84724523__muster
nester64124183ne__ster
omitter9298503_omitter
palmister1345053palmister
penster92811953pe_nster
peripter1278753peripter
permitter1345963permitter
persister1146833persister
pester84827593pe__ster
plaister1068013plaister
reciter94117263reci_ter
refilter1137153refilter
registers1038893registers
reinter73116843re_inter
relisted9312623relisted
remasters11310583remasters
reminder113110513reminder
reminted113615083reminted
remise84221953remis_e_
remised103516843remis_ed
remises93423483remis_es
remitted113312073remitted
remitters11328403remitters
remittor10316553remittor
remoisten11175883remoisten
remoter94815973rem_oter
resisted9312693resisted
resisters9310453resisters
resistor847673resistor
rester63832433re__ster
reviser104114663revis_er
rimester1037813rimester
roister73516203_roister
seamster1037143seamster
seiser65318343se_is_er
semesters1139123semesters
semises93916553semis_es
sinister838583sinister
sister64421583__sister
smiter83616413_smi_ter
teamster1036293teamster
tempter11358213tem_pter
tester64227153te__ster
twister10308953_twister
unmiter9310393unmi_ter
vomiter1237953vomi_ter
waister103812383_waister
webmaster1643003webmaster
webster1236093we_bster
wester94222893we__ster
yester93417983ye__ster
zester153617793ze__ster

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622527.84318636.0
3Display Results2522520.0932709.7
 (SQL Overall)1786912528.35921377.1
 
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.