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

187 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
deicides124930(None) 
decides114217651de_cides
deicide1149401deicide_
debrides1268722debrides
decades113615512de_cades
decide104116872de_cide_
decided124312422de_cided
decider114213182de_cider
deciders123510752de_ciders
deciles104417722de_ciles
decodes113914982de_codes
deices94119372deic__es
deicidal1245712deicidal
deifies113317452deifi_es
deities82621922deiti_es
deixises1635692deixises
depsides1238502depsides
derides93420852de_rides
divides123211452d_ivides
excides1738342_excides
feticides1547002feticides
medicides1556582medicides
ovicides1445462ovicides
regicides1345812regicides
suicides1139082suicides
algicides1344863algicides
bedsides1246533bedsides
besides104814533be_sides
betides104915263be_tides
biocides1336933biocides
ceilidhs1442133ceilidhs
cercises12410933cercises
coincides1446433coincides
dacites101114593d_acites
dailies84219263daili_es
dairies84217733dairi_es
daisies84217093daisi_es
daysides1335963daysides
dearies83526273deari_es
debride1138593debride_
debrided1336583debrided
decade104216163de_cade_
decanes103118913de_canes
decares102818533de_cares
deceives1437903deceives
deciares11510633deciares
decibel1235993de_cibel
decibels1344523de_cibels
decidua1144493de_cidua
deciduas1243463de_ciduas
decile94619213de_cile_
deckles143312803de_ckles
declines113315803declines
decode104414743de_code_
decoded123212383de_coded
decoder113712293de_coder
decoders122810413de_coders
decrees102513123de_crees
decries103319803de_cries
dedicates13311693dedicates
deficits1447273defici_ts
defies104624053de_fi_es
defilades14134073defilades
defiles114016843de_files
defines114118683de_fines
degrades11269923degrades
deice84320033deic__e_
deiced104214483deic__ed
deicer94114413deic__er
deicers103612733deic_ers
deicing11312193deici_ng
deictics1345563deictics
deified123112413deifi_ed
deifier113013123deifi_er
deifiers12348993deifiers
deionizes1958213deionizes
deixis1437243deixi__s
delaines9312963delaines
delicates12314313delicates
delicious1246713delicious
delimes10314193de_limes
dellies83622213delli_es
deludes91810643de_ludes
demies94825803de_mi_es
demises103719563de_mises
denies74729643de_ni_es
dentines93418403dentines
denudes91510043de_nudes
deprives1438393deprives
depside1138403depside_
derbies103016053derbi_es
deride84420033de_ride_
derided102914253de_rided
derider93214973de_rider
deriders102411853de_riders
derives114017813de_rives
dermises112512023dermises
derries83124623derri_es
derrises93012783derrises
describes1446003describes
descries11311923descries
desires81316133de_sires
desmids1166603desmid_s
despises1139433despises
despites11410313despites
destines93619663destines
detrudes1036203detrudes
deuces94015513deuc__es
devices133212583de_vices
devises114116763de_vises
devoices14307413devoices
dexies145018343de_xi_es
diacids1137863diacid_s
diamides1238823diamides
dices86434243d_ic__es
dicier94416233d_ici_er
diciest103316523d_ici_est
dickies143416343d_ickies
didies84621833d_idi_es
diecious1146873diecious
diodes83915783d_i_odes
dioxides1756203dioxides
divide113410893d_ivide_
divided13378593d_ivided
divider12278953d_ivider
dividers13257213d_ividers
divines113514723d_ivines
doilies84017363doili_es
domiciles1445423domiciles
ecocides1346583ecocides
edifices1454863edifices
edifies113012283edifi_es
elides74420693_e_lides
encodes10310643_encodes
excide1638423_excide_
excided1836203_excided
excises1638933_excises
excites16310633_excites
feticide1447503feticide_
filicides1545943filicides
genocides1345003genocides
germicides1684113germicides
heinies102514543heini_es
herbicides1884193herbicides
homicides1745853homicides
ileitides1045613ileitides
imides94515343__imides
irides74519123__irides
laicises1039573laicises
laicizes1937403laicizes
leucines1037273leucines
leucites1037333leucites
lipides103810623_lipides
medicide1447713medicide_
medicines1447903medicines
meinies92516073meini_es
mercies113817563merci_es
miticides1447083miticides
nereides938503nereides
otitides937293otitides
ovicide1346433ovicide_
peptides132610263peptides
pesticides1546723pesticides
pulicides1446283pulicides
raticides1248693raticides
recedes102816063re_cedes
recipes113314463re_cipes
recites93524583re_cites
recodes102918633re_codes
redecides1356563redecides
redivides1445683redivides
regicide1245923regicide_
reifies104218283reifi_es
reincites1148493reincites
resides84523283re_sides
seasides938743seasides
secedes103711983se_cedes
seiches12513813seic_hes
silicides1247073silicides
suicide1038893suicide_
suicided1246033suicided
teiids736693tei_id_s
vaticides1546603vaticides
verbicides18104373verbicides
vermicides1894913vermicides
viricides1545803viricides
weirdies12255783weirdies

Search took 9 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 Limit1461621877.64019131.2
3Display Results1871870.0632968.3
 (SQL Overall)1786911878.12621990.0
 
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.