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

240 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
excide163842(None) 
excided1836201excided
excides1738341excides
excise1538551excise
excite15310881excite
decide104116872decide
deicide1149402deicide
ecocide1246732ecocide
eide55832232e__ide
elide64922642e_lide
encode9310442encode
exceed1636172exceed
excimer1834962excimer
exciple1874682exciple
excised1736672excised
excises1638932excises
excited1737852excited
exciter1637752exciter
excites16310632excites
exclude1744452exclude
excuse1537422excuse
exile126117652ex_ile
exine125518492ex_ine
expire1538022expire
exude134010292ex_ude
oxide131210952ox_ide
abide86223713_abide
accede1138293accede
accidie1247733accidie
acid77533393_acid_
acids87121003_acids
acidy117214893_acidy
aide56044993__aide
alcade91111513alcade
alcaide1088453alcaide
alcid85817973alcid_
alcids94812293alcids
amide86128483_amide
arcade91013643arcade
aside65122083_aside
axile126020513ax_ile
axite125218253ax_ite
axlike17388853axlike
azide155617163_azide
bedside1156843bedside
beside95114613beside
betide95115973betide
bide76041483__bide
biocide1237323biocide
bolide9515563bolide
boride9415903boride
bride86425533_bride
cade76443913__cade
cede74928763__cede
chide115321013_chide
cider84723313__cider
cine66242943__cine
cire65836373__cire
cite65640343__cite
code77347733__code
dacite91115883dacite
debride1138593debride
decade104216163decade
decided124312423decided
decider114213183decider
decides114217653decides
decile94619213decile
decode104414743decode
deicides1249303deicides
depside1138403depside
deride84420033deride
dexie134716893dex_i_e
divide113410893divide
docile94213123docile
eccrine1137283eccrine
eche97520283e_c_he
eched116919223e_ched
ecocides1346583ecocides
eddied9248323eddied
edile64819493e_dile
eerie55228533eeri_e
eider64624743e__ider
elided84814673e_lided
elides74420693e_lides
elite56230183e_lite
elude64517623e_lude
emcee9315943emc_ee
emceed1136283emceed
empire1039323empire
emyde1136383e_myde
encage93713503encage
encase83714363encase
encina8310443encina
encoded1139033encoded
encoder1038633encoder
encodes10310643encodes
encore8314773encore
endite73817593endite
endive103310473endive
engine71114863engine
ensile62616473ensile
entice81316863entice
entire61617703entire
envied1038833envied
eocene8311613eocene
eosine64519413eosine
epode85114093e_pode
epoxide1745343epoxide
equid154610323equid_
equids16439143equids
equine151711573equine
ermine8416923ermine
erode64520993e_rode
escape103811663escape
escudo943373escudo
espied9359773espied
etched123613703etched
etoile6312263etoile
etude63612303e_tude
eucaine939243eucaine
euchre11137663euchre
eucrite939903eucrite
evade938183e_vade
evite85317683e_vite
exacted1737303exacted
examine161510033examine
exceeded1943493exceeded
exceeder1843953exceeder
exceeds1733843exceeds
excel1437743exc_el
excels1536663excels
except1797653except
excess1546053excess
exciding1935923exciding
excimers1944703excimers
exciples1964773exciples
exciters1736323exciters
exciton1646083exciton
excitor1645993excitor
exclave1945193exclave
excluded1943433excluded
excluder1843453excluder
excludes1844383excludes
excrete1667163excrete
excused1736293excused
excuser1635813excuser
excuses1638903excuses
execute1636783execute
exed125420593ex_ed_
exercise1747063exercise
exhale1636873exhale
exhume1833803exhume
exiled144712463ex_iled
exiler134712183ex_iler
exiles134816403ex_iles
exines135715803ex_ines
exing136016813ex_ing
exist124618943ex_ist
exit114428673ex_i_t
exited144712523ex_ited
exits125515913ex_its
exocrine1745993exocrine
exorcise1745933exorcise
exorcize2644893exorcize
expiate16910593expiate
expired1736403expired
expirer1635993expirer
expires1638683expires
expiry1834653expiry
explode1745963explode
expose1549523expose
exscind1743753exscind
exscinded2042223exscinded
exscinds1842533exscinds
extrude1545013extrude
exuded15317683ex_uded
exudes143710363ex_udes
exuviae1744343exuviae
eyrie88117833eyri_e
facade1238803facade
faciae112913413faciae
facile112514883facile
feticide1447503feticide
genocide1245693genocide
glide74521593_glide
gride75223583_gride
guide75019883_guide
halide103417993halide
hexade17438903hex_ade
hide85134623__hide
imide85716893_imide
incise83515333incise
incite83618733incite
inside7613453inside
iodide84812933iodide
leucine938073leucine
leucite937753leucite
lipide93511063lipide
lucid84314573lucid_
lucite8313343lucite
medicide1447713medicide
mucid104115253mucid_
nide55535783__nide
nuclide1037173nuclide
onside7511803onside
oreide7311673oreide
oroide7311703oroide
oscine8311563oscine
ovicide1346433ovicide
oxid12815483ox_id_
oxides14109693ox_ides
oxids13128963ox_ids
oxime1498433ox_ime
oxlike17307473oxlike
peptide122910683peptide
pride84724733_pride
recede95515533recede
recipe103414893recipe
recite83625113recite
recode93618713recode
redecide12127183redecide
regicide1245923regicide
reside74224933reside
rexine134719443rex_ine
ride55945123__ride
seaside839693seaside
secede93311993secede
sextile1438573sextile
side55444483__side
slide64725413_slide
snide64318723_snide
stride75420963stride
suicide1038893suicide
textile1437223textile
tide55237373__tide
unciae83215313unciae
upside9289803upside
ureide7310363ureide
vide85432753__vide
wide85235403__wide

Search took 6 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.1401276364.3
2DLD Change Limit1127162405.73619650.6
3Display Results2402400.0763157.9
 (SQL Overall)1786912405.95230022.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.