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

151 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
suicide103889(None) 
suicided1246031suicided
suicides1139081suicides
deicide1149402deicide
ovicide1346432ovicide
pulicide1347042pulicide
silicide1147832silicide
subcode1237162subcode
subside10410452subside
suicidal1146072suicidal
sulfide1138102sulfide
algicide1245563algicide
biocide1237323biocide
coincide1346493coincide
cuisine9310423cuisine
culicid1247383culicid_
culicids1345623culicids
culicine1248343culicine
decide104116873_decide
deicides1249303deicides
divide113410893_divide
ecocide1246733ecocide
excide1638423_excide
feticide1447503feticide
filicide1446363filicide
fungicide1642553fungicide
guide75019883gu__ide
homicide1646463homicide
imide85716893__imide
juice14311323juic__e
juiced1636513juiced_
juicier1635463juicier
juicily1935493juicily
juicing1736883juicing
laicise939333laicise
laicize1838093laicize
lipide93511063_lipide
lucid84314573lu_cid_
lucite8313343lu_cite
medicide1447713medicide
miticide1347863miticide
mucid104115253mu_cid_
muscid11219833muscid_
muscids12187973muscids
nuclide1037173nuclide
outchide1447213outchide
outride82615683outride
outside82414193outside
ovicides1445463ovicides
pesticide1447283pesticide
pulicides1446283pulicides
pumicite1446813pumicite
quiche2057903quic_he
quickie2235513quickie
quinine163011043quinine
raticide1148943raticide
regicide1245923regicide
saccade12107033saccade
saice75424053saic__e
saiyid10167413saiyid_
saiyids11174893saiyids
salicine10311703salicine
seaside839693seaside
secede93311993s_ecede
seiche11811833seic_he
shipside1445033shipside
sicced11489653s_icced
sice65545593s_ic__e
sicked134524403s_icked
sickee124622223s_ickee
sickie123715743s_ickie
sickle124418323s_ickle
side55444493s___ide
silicides1247073silicides
simile83115633s_imile
sinicize1947333sinicize
slice74925823slic__e
sliced94416313sliced_
slicing103514643slicing
slicked144413843slicked
slide64725413s__lide
sluice849513sluic__e
sluiced1046053sluiced_
sluicing1137063sluicing
snicked143811633snicked
snide64318723s__nide
soricine10710883soricine
specie10412223speci_e
spicae104313703spic_ae
spicate113214193spicate
spice95528813spic__e
spiced115218313spiced_
spicier115112463spicier
spicily1438653spicily
spicing123914533spicing
spicule11269933spicule
sporicide1484793sporicide
stibine938663stibine
sticked144114633sticked
stickle132410973stickle
stimied10310623stimied
stride75420963s_tride
suasive1037853suasive
subacid1248473subacid_
subcodes1338143subcodes
subdivide1643613subdivide
subfile122010503subfile
subidea1037533su_bidea
sublime11310363sublime
subline9316893subline
suboxide1845213suboxide
subsided1257663subsided
subsider1138243subsider
subsides11410823subsides
subsidy1345973subsidy
subsite9412873subsite
subtile91912623subtile
succeed1235983succeed
sucked134120493su_cked
suckle124015963su_ckle
sucre75019103su_c_re
suede64419753su__ede
suffice15197573suffice
suiciding1345453suiciding
suitcase1043893suitcase
suite54829563su__ite
suited74019423suited_
suiting83419003suiting
suitlike1236313suitlike
sulcate9314423sulcate
sulci7615053sulci__
sulfid1039063sulfid_
sulfides1238053sulfides
sulfids1137293sulfids
sulfite10310473sulfite
sullied83714483sullied
sulphide1444623sulphide
sunlike112310573sunlike
sunrise7310813sunrise
sunwise1036433sunwise
supine84216693su_pine
surfside1244853surfside
suricate10312613suricate
surmise9311083surmise
survive1335933survive
suspire937803suspire
unciae83215313_unciae
upside9289803_upside
ureide7310363_ureide
vaticide1446863vaticide
viricide1446423viricide

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 Limit1340271516.11021935.7
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.56227231.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.