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

211 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
bemisted136838(None) 
befitted14305722befitted
bekissed1543162bekissed
bemired123410632bemi_red
bemist105216962bemist__
bemists113410702bemist_s
bemixed19337052bemi_xed
bemused1236712bemus_ed
bested94922762be__sted
blemished1763782blemished
delisted10310562delisted
demasted1238762demasted
demised113613682demis_ed
demister11310222demister
demitted12288772demitted
desisted1039782desisted
emitted103010852_emitted
existed1538472_existed
heisted113210652he_isted
misted93625822__misted
relisted9312622relisted
reminted113615082reminted
remised103516842remis_ed
remitted113312072remitted
resisted9312692resisted
admitted1234763admitted
agisted938203_agisted
assisted936233assisted
baited95319243b_ai_ted
banished14189073banished
banister10199973banister
basted95227233b__asted
batiste939743batiste_
batistes1039713batistes
becrusted1443953becrusted
bedighted1744583bedighted
bedimmed1643443bedimmed
bedirtied1393733bedirtied
bedotted1234983bedotted
bedstead1253403be_dstead
begirded1334173begirded
bekisses1434243bekisses
belated103520013be_lated
belied95022163beli__ed
believed14427923believed
belittled1243033belittled
belted94020633be__lted
bemeaned1335783bemeaned
bemingled1544083bemingled
bemire103312803bemi_re_
bemires113212833bemi_res
bemisting1438073bemisting
bemixes18338653bemi_xes
bemixt174510363bemixt__
bemoaned1335553bemoaned
bemocked1934073bemocked
bemuse1038943bemus_e_
bemuses1139293bemus_es
benighted1644743benighted
bepainted1484343bepainted
berated104422133be_rated
berimed124912283beri_med
beringed1298173beringed
besieged1234733besieged
besmiled1335503besmi_led
besmutted1442683besmutted
besotted1135843besotted
bestead10389123be__stead
bestud9439303be__stud
betided114810203beti_ded
betise85616273betis_e_
betises94816123betis_es
betted94721163be__tted
bevomited1742773bevomi_ted
bewigged1643383bewigged
bewinged1584473bewinged
bilsted1038033b_ilsted
bimester1236163bimester
bister84922763b__ister
bistred103311853b__istred
bitted94418483b__itted
blasted104213473b_lasted
blemisher1663653blemisher
blemishes1665083blemishes
blissed10388373b_lissed
blister94415313b_lister
boasted104113743b_oasted
boosted104111983b_oosted
braised104014803brais_ed
breasted1138823breasted
brisked144210003b_risked
bristled11187343b_ristled
bruised10389503bruis_ed
bruited104110353brui_ted
bursted1039423b_ursted
busted95123153b__usted
cemented1338373cemented
cisted95217523__cisted
coexisted1944153coexisted
debited113311623debi_ted
degusted1135733degusted
dehisced1583683dehisced
demented12311273demented
demise94618323demis_e_
demises103719563demis_es
demisters1249203demisters
demoted114313543dem_oted
dempster1355773dempster
depicted1437743depicted
detested10279623detested
devested13239133devested
deviated13311043deviated
devised123712563devis_ed
edited83913673_edi_ted
egested938123_egested
emitter93211083_emitter
emoted94614923_em_oted
enisled82510223_enisled
enlisted978193enlisted
evicted1337243_evicted
evited104013143_evi_ted
exited144712523_exi_ted
famished1766023famished
feasted11310843fe_asted
feinted11379623fe_inted
fisted104218703__fisted
flemished1853633flemished
foisted113210603_foisted
geminated1338553geminated
gemmated14336293gemmated
heister103613623he_ister
hemipter1545583hemipter
hempseed1643623hempseed
histed104420243__histed
hoisted113411293_hoisted
insisted998673insisted
itemised11105163itemis_ed
jested144416503je__sted
joisted15379173_joisted
keister113011573ke_ister
lamister1037653lamister
leister73212753le_ister
lenited8812433leni_ted
limited102310233limi_ted
listed74322833__listed
masted94025803__masted
mediated123011873mediated
meister93114163me_ister
meristem1245743meristem
merited10313853meri_ted
milted93919943__milted
minted94220583__minted
misfed124113023__misfed
misled94719313__misled
missed94423603__missed
mistend103812523__mistend
mister84728563__mister
musted93321073__musted
nested74720073ne__sted
obelised1136173obelis_ed
oersted839563oe_rsted
omitted10347893_omitted
peised94817683pe_is_ed
perished14310093perished
permitted1446653permitted
persisted1247153persisted
premised133013193premis_ed
recited104319103reci_ted
reemitted1245943reemitted
reested82916233re_ested
refitted12309413refitted
register939553register
relished1239433relished
remaster10311473remaster
remated103522473rem_ated
remelted11310153remelted
reminded123411523reminded
remise84221953remis_e_
remises93423483remis_es
remitter102810323remitter
remixed173510743remi_xed
remoisten11175883remoisten
renested92212953renested
repasted112611533repasted
resifted12310153resifted
resister8311653resister
resited85122423resi_ted
rested74430783re__sted
retasted92412113retasted
retested92212533retested
retinted94414363retinted
retwisted1344893retwisted
revested122612243revested
revised113815483revis_ed
revisited1346573revisited
seised74218123se_is_ed
semester1038903semester
semises93916553semis_es
seriated92717023seriated
tempested1444033tempested
tempted12317283tem_pted
tested74421523te__sted
twisted11277433_twisted
unlisted9311153unlisted
vested104217353ve__sted
vomited1337253vomi_ted
waisted114210943_waisted
whisted144010013_whisted
wisted104120273__wisted
yeasted1138503ye_asted
zested164214043ze__sted

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.436409841.7
2DLD Change Limit1461622117.73318901.1
3Display Results2112110.0802637.5
 (SQL Overall)1786912118.24921662.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.