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

228 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
emerod913921(None) 
emerods10137651emerods
emeroid101511181emeroid
emend86214892eme_nd
emerald1046922emerald
emerge91510462emerge
emerged11158212emerged
emeroids11147722emeroids
emersed10138512emersed
emery104814332emer_y
emperor1155482emperor
aero45435343_aero_
amberoid1346433amberoid
ambroid1238883ambroid
ameboid1277233ameboid
amend85717753ame_nd
amerce10310513amerce
amerced1256523amerced
aneroid8314013aneroid
bemired123410633bemired
cered85227443_cered
cero66329453_cero_
ceros74726073_ceros
clerid9312413clerid
demerge11168023demerge
demerged13157603demerged
demerit10314993demerit
demeton1037683demeton
demigod1254193demigod
eared65139503e_ared
eerie55228533e_erie
eery76129623e_er_y
eger55923573eger__
egers65120373eger_s
eked96718033eke__d
elevon977953elevon
embed105014303em_bed
ember95516803ember__
embers104116183ember_s
embody1435033em_body
embow1297563em_bow
embroil1146613embroil
embrown1454803embrown
embrue1036533embrue
embrued1235293embrued
embryo1363963embryo
embryoid1644403embryoid
embryon1474063embryon
embryos1464093embryos
emceed1136283emceed
eme55837183eme___
emeer74815363eme_er
emeers83314183emeers
emended11329603emended
emends95711433emends
emeralds1144593emeralds
emerges101310883emerges
emeries91620023emeries
emerita938713emerita
emeriti949433emeriti
emersion1047733emersion
emes65434663eme__s
emeses86114963emeses
emesis84712623emesis
emetic10614453emetic
emetin8613463emetin
emeu66723433eme__u
emeus76913333eme_us
emeute838533emeute
emir65918703emir__
emirs76116163emir_s
emmer94314463emmer__
emmers104013223emmer_s
emoted94614923emoted
emperors1256123emperors
empery1348683emper_y
employ1346493employ
emyd1047073em__yd
energid948303energid
energy10137513energy
enrol51014283e_nrol
entered82718883entered
enteron7313343enteron
enured73315333enured
ephod1139123e_phod
erenow937373erenow
erode64520993__erode
eros45238453__eros
erred65915673e_rred
error53712233e_rror
escrow1135913escrow
eterne6311723eterne
euro45325273e_uro_
euros54920243e_uros
evened101010313evened
ever77027693ever__
evert84929513ever_t
everted112711853everted
evertor1038723evertor
everts94514893everts
every115215453ever_y
ewer77523983ewer__
ewers86018823ewer_s
exed125420593exe__d
exert124624143exer_t
exerted152210053exerted
exerts133712293exerts
eyebrow1542873eyebrow
eyed86623233eye__d
eyefold1443343eyefold
eyelid1038443eyelid
eyer76127283eyer__
eyers86521333eyer_s
feod815523003_fe_od
fevered14339723fevered
herd84933063_her_d
hero74635783_hero_
heron85025503_heron
heros84930863_heros
hetero9312633hetero_
heteros10312683heteros
homered133212713homered
hotrod1048803hotrod
improv1344643improv
jeered143912793jeered
jerid132316423_jerid
leered73816223leered
lemuroid11115173lemuroid
levered114212303levered
mead75531603_me_ad
med66146753_me__d
meed74934703_me_ed
meld75830473_me_ld
melody1237203_melody
meloid9616003_meloid
melon73922083_melon
membered1535903membered
memo85924793_memo_
memos95719113_memos
menad85918983_menad
mend75334033_me_nd
meno66031363_meno_
meou65325863_me_ou
meow95117883_me_ow
merc87225623_mer_c
merch125417963_merch
mercs96020453_mercs
mercy125916183_mercy
merde84320123_merde
mere67244443_mer_e
merer75126233_merer
meres75143573_meres
merge84523693_merge
merged104214953_merged
merit7339183_merit
merk106027943_mer_k
merks114722403_merks
merl65830973_mer_l
merle75824373_merle
merlon83012353_merlon
merlot83217613_merlot
merls77423903_merls
merry104721493_merry
meson74118313_meson
meted85424433_meted
metered103514013metered
method1239033method
metol75917813_metol
metred95315143metred
metro74718803metro_
metros84217803metros
mewed115218013_mewed
mired85729223_mired
mod69054413_m__od
mood76332063_m_ood
moron76925423_moron
mured85726703_mured
murid84520583_murid
nerd56624943_ner_d
nerol51017813_nerol
nimrod934873nimrod
omened93711003omened
omer67028393omer__
omers76923193omer_s
operon8811773operon
overdo10128363overdo
overed102216623overed
peered93819493peered
period9314983_period
pernod9310453_pernod
petered103314973petered
prod76129503__prod
ramrod936833ramrod
remend95216553reme_nd
remerge10148923remerge
remerged12149173remerged
remorid10311863remorid
resod64720053_resod
revered112819333revered
rezero1578873rezero_
rezeroed1835993rezeroed
rezeros1647453rezeros
rod47953903___rod
sarod65325873_sarod
schrod1247883schrod
scrod85115073_scrod
sered65737293_sered
serow86720443_serow
severed113513863severed
sewered112911243sewered
sherd96321153sher_d
smeared104510623smeared
smerk115412723smer_k
smerked14327283smerked
smerks12449713smerks
steroid81314873steroid
sterol6613333sterol
tempered13248223tempered
theroid11313403theroid
tiered73613973tiered
trod57627953__trod
umbered121510113umbered
untrod769853untrod
veered103612743veered
xerox1138623_xerox
zero134822473_zero_
zeroed16409423_zeroed
zeros144918113_zeros

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162285.70319764.3
3Display Results2282280.0763000.0
 (SQL Overall)1786912286.15529031.8
 
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.