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

210 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
desmids116660(None) 
desmid1048361desmid_
desmoids1244971desmoids
cosmids1237632cosmids
demies94825802de_mies
demits94918072de_mits
dermis94717162dermi_s
dermoids1246162dermoids
desands94810162desands
desmans1039002desmans
desmoid1137102desmoid_
dismiss1038152dismiss
resids74219152res_ids
vespids1334612vespids
adenoids1056863adenoids
agamids11317013agamids
amids85627513__amids
aramids102810513aramids
beside95114613bes_ide
besides104814533bes_ides
besmile1137463besmile
besmiles1237393besmiles
besmuts1134683besmuts
bestirs9311133bestirs
bestuds10326753bestuds
bromids12278603bromids
cebids11439173ce_bids
ceboids1237653ceboids
cestoids11308273cestoids
cosmid11810643cosmid_
cuspids12427113cuspids
daimios1035753daimios
dashis104414393dashi_s
dassies84418663dassies
deads75726913de__ads
deairs74013783de_airs
dearies83526273dearies
debits94214503de_bits
debride1138593debride
debrides1268723debrides
debris93311493debri_s
deceits102810883deceits
decide104116873de_cide
decides114217653de_cides
decries103319803decries
deeds75423763de__eds
deemed104713063deemed_
deeming113913123deeming
deems85421773deem__s
defends12358773defends
defies104624053de_fies
defis96717503de_fi_s
defunds12376753defunds
degamis11268443degami_s
deicide1149403deicide
deicides1249303deicides
deifies113317453deifies
deils65722863de__ils
deisms94411043deism__s
deities82621923deities
deixis1437243deixi_s
deleads9379703deleads
delimes10314193delimes
delimits1137573delimits
delis64928543de_li_s
dellies83622213dellies
deltoids1045483deltoids
demands114311413demands
demes86032693de_m_es
demic105119193de_mi_c
demigods1343983de_migods
demise94618323de_mise
demises103719563de_mises
demit84832303de_mi_t
demobs11429483de_mobs
demode104013463de_mode
demons94917723de_mons
demos86022993de_m_os
demurs939773de_murs
denies74729643de_nies
denims95214323de_nims
dentils84115583dentils
dentins83419223dentins
depends11348993depends
depside1138403depside
depsides1238503depsides
derails84216393derails
derbies103016053derbies
deride84420033de_ride
derides93420853de_rides
dermas94116813derm_as
dermic114511913dermi_c
dermises112512023dermises
dermoid1138523dermoid_
derms85022893derm__s
derries83124623derries
derris73615273derri_s
desalts839573desalts
desand84812633desand_
descends12266983descends
descries11311923descries
deserts82513053deserts
desexes1537833desexes
design8408933des_ign
designs9328313designs
desire7415303des_ire
desires81316133desires
desist74818813des_ist
desists83611723desists
desks105913073des__ks
desman9311693desm_an
desmidian1343053desmidian
desorbs10437713desorbs
despairs1144943despairs
despise1038683despise
despises1139433despises
despite10410123despite
despites11410313despites
despoils1145623despoils
desponds1246243desponds
despots10319683despots
destains9311813destains
destine83719953destine
destines93619663destines
destiny113111463destiny
details84214043details
detains83716093detains
deveins1138813deveins
devils104412813de_vils
devoid1189363devoid_
devoirs1175783devoirs
dexies145018343de_xies
diacids1137863diacids
diamide1138473diamide
diamides1238823diamides
diamins10312213diamins
diesis74013493dies_i_s
dioxids1655683dioxids
disbuds11125243disbuds
discoids1239873discoids
dismals102010243dismals
dismays13237433dismays
dismes95617673dism_es
distils83015803distils
doeskins1344903doeskins
dormins10311273dormins
dossils8669773dossils
droids84712583d_roids
druids8368093d_ruids
dummies123012133dummies
emirs76116163_e_mirs
emits75421473_e_mits
emyds1144923_e_myds
equids16439143_equids
espies83716803_espies
felids103111623fe_lids
fermis114313503fermi_s
geoids8369843ge_oids
hemins113417573he_mins
hermits12312143hermits
imids86015143__imids
jasmins1637083jasmins
jassids1586143jassids
jemmies18318333jemmies
jerids142810943je_rids
jerrids15277743jerrids
jesuits1436323jesuits
keloids1288663keloids
kermis124012393kermi_s
masjids17175403masjids
meloids10911453meloids
mermaids1355753mermaids
mids76541793___mids
muscids12187973muscids
musjids17185713musjids
mysids1246563mys_ids
nereids838743nereids
osmics1036463_osmics
peptids12239323peptids
permits11314003permits
phasmids16195183phasmids
plasmids13236553plasmids
rebids94015533re_bids
reemits9611303reemits
reminds104614793re_minds
remiss84216353re_miss
remits85622943re_mits
resaid74517083resaid_
resails74616743resails
rescinds1136333rescinds
reseeds84012333reseeds
resends83513713resends
reships1239863reships
resid64124093res_id_
reside74224933res_ide
resides84523283res_ides
resins64528773res_ins
resits64725563res_its
resods74116303res_ods
saids65328853__saids
semis74623533se_mi_s
sesamoids1243053sesamoids
skids104615333__skids
teiids736693te_iids
testis64916713testi_s
ursids737823urs_ids
verbids13259203verbids
vermis114214963vermi_s
vespid1246083vespid_
weskits1434743weskits

Search took 7 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.423422437.4
2DLD Change Limit1340272106.01322289.5
3Display Results2102100.0802625.0
 (SQL Overall)1786912106.51627423.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.