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

136 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
emeroid10151118(None) 
emerod9139211emero_d
emeroids11147721emeroids
amberoid1346432amberoid
ambroid1238882ambroid
ameboid1277232ameboid
aneroid8314002aneroid
embroil1146612embroil
embryoid1644402embryoid
emerald1046922emerald
emerged11158212emerged
emerods10137652emerods
emersed10138512emersed
energid948302energid
lemuroid11115172lemuroid
meloid9616002_meloid
steroid81314862steroid
theroid11313402theroid
acaroid103512313acaroid
adenoid959253adenoid
amberoids1445333amberoids
ambroids1346503ambroids
amerced1256523amerced
amoeboid1344113amoeboid
amyloid1348543amyloid
android9311513android
aneroids9310203aneroids
aroid65428343__aroid
asteroid9511193asteroid
ceboid11310653_ceboid
centroid1159313centroid
cervid1239323_cervid
cheloid13310833cheloid
choroid13311803choroid
clerid9312413cler_id
ctenoid1078683ctenoid
demerged13157603demerged
demerit10314993demer_it
dendroid1145923dendroid
dermoid1138523_dermoid
devoid1189363_devoid
droid74218543__droid
eerie55228533e_er_ie
elytroid1244963elytroid
embroider1444233embroider
embroiled1444593embroiled
embroils1245773embroils
embrown1454793embrown
embrued1235293embrued
embryoids1743393embryoids
emend86214893eme__nd
emended11329603emended
emeralds1144593emeralds
emerge91510463emer_ge
emerges101310883emerges
emerging1237893emerging
emeries91620023emeries
emerita938713emerita
emeriti949433emeriti
emersion1047733emersion
emery104814333emer__y
emesis84712623eme_sis
emetic10614453eme_tic
emetin8613463eme_tin
emperor1155483empero_r
emperors1256123emperors
emporia1148753emporia
emulsoid1143773emulsoid
energids1045583energids
ericoid1049893ericoid
ethmoid1345803ethmoid
euploid1038963euploid
everted112711853everted
exerted152210053exerted
eyefold1443343eyefold
eyelid1038443eye_lid
fervid1337513_fervid
fibroid1337243fibroid
geoid74215763_ge_oid
glenoid937803glenoid
haemoid1337203haemoid
hematoid1449753hematoid
hemoid12313513_hemoid
heroic113516923_heroic
heroin94420593_heroin
hydroid1539713hydroid
hyenoid1448613hyenoid
jerid132316423_jer_id
jerrid14259143_jerrid
keloid11812623_keloid
labroid1038823labroid
lemuroids12113683lemuroids
meloids10911453_meloids
memoir1037213_memoir
merged104214953_merged
merit7339183_mer_it
merlin83916683_merlin
mermaid1297853_mermaid
meropia1149613_meropia
meropic13310263_meropic
meteoroid1245113meteoroid
morbid112511463_morbid
mucoid1139783_mucoid
murid84520583_mur_id
myeloid13108123myeloid
myoid11512993_m_yoid
myxoid1936883_myxoid
naevoid1194593naevoid
negroid9108893negroid
nereid7312923_nereid
neuroid81110303neuroid
nevoid1098793_nevoid
oceloid1037973oceloid
ochroid1357903ochroid
overbid132710273overbid
overdid12199173overdid
percoid12312313_percoid
period9314983_period
peroxid17310273_peroxid
remerged12149173remerged
remorid10311863remor_id
rezeroed1835993rezeroed
scleroid1147213scleroid
smerked14327283smerked
sparoid102311543sparoid
spheroid1447283spheroid
spiroid10219823spiroid
sporoid102310733sporoid
steroids9911443steroids
thyroid1438253thyroid
toroid7416013_toroid
tuberoid1146013tuberoid
verbid122311313_verbid
viroid10411523_viroid
zebroid1936463zebroid
zeroed16409413_zeroed

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.406440125.6
2DLD Change Limit1340271365.84322938.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.29528386.2
 
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.