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

133 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
dermoid113852(None) 
dermoids1246161dermoids
desmoid1137101desmoid
cormoid12310402cormoid
deltoid938572deltoid
demoed103713442de_moed
dentoid9310662dentoid
dermatoid1345832dermatoid
dermic114511912derm_ic
dermis94717162derm_is
desmid1048362desm_id
desmoids1244972desmoids
devoid1189362de_void
droid74218542d_r_oid
hemoid12313512he_moid
mermaid1297852mermaid
percoid12312322percoid
adenoid959253ade_noid
aneroid8314013aner_oid
aroid65428343_ar_oid
barmaid1238213barmaid
bermed115217723berm_ed
bromid112612893_bromid
ceboid11310653ce_boid
ceratoid1149923ceratoid
cervid1239323cer_vid
cestoid104011673cestoid
cirsoid1038123cirsoid
cymoid1459473_cymoid
deemed104713063deem_ed
deltoids1045483deltoids
demand104314253de_mand
demic105119193de_m_ic
demit84832303de_m_it
demo77427553de_mo__
demob104913503de_mo_b
demobs11429483de_mobs
demode104013463de_mode
demoded123611123de_moded
demoing11311753de_moing
demon86520313de_mo_n
demonic12311223de_monic
demons94917723de_mons
demos86022993de_mo_s
demote94817803de_mote
demoted114313543de_moted
demotic12412353de_motic
dendroid1145923dendroid
derail74218813der_ail
derated93623503derated
deride84420033der__ide
derided102914253derided
derived123912763derived
derm76031893derm___
derma84918523derm__a
dermal93614353derm_al
dermas94116823derm_as
dermestid1343533dermestid
derms85022893derm__s
derris73615273der_ris
desmids1166603desm_ids
despoil1046523despoil
despond1137513despond
devoir1076033de_voir
diamond1186113diamond
diploid11310293diploid
discoid11311243discoid
dormie9312623dorm_ie
dormin9312313dorm_in
droids84712583d_r_oids
droit65127123d_r_oit
dromond1135473dromond
druid74111323d_r_uid
emeroid101511183emer_oid
epidermoid1652453epidermoid
ericoid1049893_ericoid
ethmoid1345803ethmoid
fermi103914163ferm_i_
fermion1236763fermion
fermis114313503ferm_is
fervid1337513fer_vid
geoid74215763ge__oid
haemoid1337203haemoid
hermai118912873hermai_
hermit11519443herm_it
heroic113516923her_oic
heroin94420593her_oin
jerid132316423jer__id
jerrid14259143jer_rid
keloid11812623ke_loid
keratoid1347273keratoid
kermis124012403kerm_is
lentoid8310683lentoid
meloid9616003me_loid
memoir1037213me_moir
mermaids1355753mermaids
negroid9108903negroid
nereid7312933ner_eid
neuroid81110313neuroid
nevoid1098803ne_void
peracid12312993peracid
percoids1339663percoids
period9314983perio_d
periodid1248163periodid
permed115217353perm_ed
permit10321683perm_it
pernod9310453perno_d
peroxid17310283peroxid
premold1247863premold
pygmoid1644533pygmoid
remold93412973re_mold
remorid10311863re_morid
sarcoid10310453sarcoid
sermon8413553sermo_n
sermonic1248883sermonic
sermons9311783sermons
sesamoid1144063sesamoid
sigmoid1146113sigmoid
steroid81314873ster_oid
teratoid9411073teratoid
termed94816703term_ed
termor84412513termo_r
termors94712773termors
theroid11313403ther_oid
toroid7416013tor_oid
turmoil944723turmoil
verbid122311313ver_bid
vermeil1285223vermeil
vermin113414523verm_in
vermis114214963verm_is
viroid10411523vir_oid
zebroid1936473zebroid
zeroed16409423zer_oed

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271336.64020184.8
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.07625253.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.