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 “dermoids” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
dermoids124616(None) 
dermoid1138521dermoid_
desmoids1244971desmoids
deltoids1045482deltoids
dermis94717162derm_i_s
desmids1166602desm_ids
desmoid1137102desmoid_
droids84712582d_r_oids
mermaids1355752mermaids
percoids1339662percoids
adenoids1056863ade_noids
aneroids9310203aner_oids
aroids75118223_ar_oids
barmaids1345943barmaids
bromids12278603_bromids
ceboids1237653ce_boids
cestoids11308273cestoids
cormoid12310403cormoid_
deltoid938573deltoid_
demands114311413de_mands
demies94825803de_m_ies
demits94918073de_m_its
demobs11429483de_mo_bs
demode104013463de_mo_de
demoed103713443de_moed_
demoing11311753de_moing
demons94917723de_mo_ns
demos86022993de_mo__s
demoses103815823de_moses
demotes104717673de_motes
demotics1338753de_motics
dentoid9310663dentoid_
derails84216393der_ails
derbies103016053der_bies
deride84420033der__ide
derides93420853der__ides
dermas94116813derm__as
dermatoid1345823dermatoid_
dermestids1452033dermestids
dermic114511913derm_i_c
dermises112512023dermises
derms85022893derm___s
derries83124623der_ries
derris73615273der_ri_s
desmid1048363desm_id_
despoils1145623despoils
desponds1246243desponds
devoid1189363de_void_
devoirs1175783de_voirs
diamonds12125173diamonds
diploids1247843diploids
discoids1239873discoids
dormins10311273dorm_ins
droid74218543d_r_oid_
droits74314313d_r_oits
dromonds1244613dromonds
druids8368093d_r_uids
emeroids11147723emer_oids
ethmoids1444053ethmoids
fermions1336203fermions
fermis114313503ferm_i_s
geoids8369843ge__oids
hemoid12313513he_moid_
hermits12312143herm_its
heroics122912003her_oics
heroins103518013her_oins
jerids142810943jer__ids
jerrids15277743jer_rids
keloids1288663ke_loids
kermis124012393kerm_i_s
lentoids947443lentoids
meloids10911453me_loids
memoirs1136803me_moirs
mermaid1297853mermaid_
negroids10116323negroids
nereids838743ner_eids
peracids13310073peracids
percoid12312313percoid_
periodids1345643periodids
periods10312243perio_ds
permits11314003perm_its
pernods1038483perno_ds
peroxids1837453peroxids
premolds1345843premolds
remolds10299703re_molds
sarcoids1137803sarcoids
sermons9311783sermo_ns
sesamoids1243053sesamoids
sigmoids1244453sigmoids
steroids9911443ster_oids
termors94712773termo_rs
toroids8310643tor_oids
turmoils1043983turmoils
verbids13259203ver_bids
vermeils1374813vermeils
vermis114214963verm_i_s
viroids1137923vir_oids

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 Limit146162976.93621073.0
3Display Results97970.0462108.7
 (SQL Overall)178691977.40524131.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.