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

161 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
diamide113847(None) 
diamides1238821diamides
diamine10311981diamine
amide86128482__amide
diacid10310632diacid_
diacids1137862diacids
diamin9312522diami_n
diamines11311642diamines
diamins10312212diamins
diazine1738932diazine
dioxide1656302dioxide
divide113410892di_vide
imide85716892_i_mide
abide86223713__abide
agamid103710693agamid_
agamids11317013agamids
aide56044993__a_ide
alamode1038153alamode
amice96122873__amice
amid77036353__amid_
amides95722663__amides
amido85720983__amido
amids85627513__amids
amie66339853__ami_e
amine75835383__amine
aramid93315613aramid_
aramids102810513aramids
aside65122083__aside
azide155617163__azide
biocide1237323biocide
bromide12269583bromide
camise103319633_camise
ceramide1347973ceramide
chamade15138453chamade
chamise143612853chamise
cyanide13298843cyanide
dacite91115883d_acite
daimio937463daimi_o
daimios1035753daimios
daisied93410013daisied
damage10410773d_amage
dame77140313d_am__e
dammed124214793d_ammed
damned104212913d_amned
damped124315583d_amped
dative10311813d_ative
dayside1236173dayside
dearie73319813deari_e
debride1138593debride
decide104116873d_ecide
deicide1149403deicide
demise94618323d_emise
demode104013463d_emode
depside1138403depside
deride84420033d_eride
desmid1048363desmid_
desmids1166603desmids
diabase1037113diabase
diacidic1444063diacidic
diadem1037583dia__dem
dialed84716453dialed_
dialing94318173dialing
dialist8517763dialist
dialled9510133dialled
dialyse1135463dialyse
dialyze2044433dialyze
diamante1186423diamante
diameter1148053diameter
diamond1186113diamond
diamonded1443393diamonded
diamonds12125173diamonds
diapir9357113diapi_r
diapirs10347643diapirs
diapsid1146703diapsid_
diapsids1244753diapsids
diaries83321953diaries
diarist8517113diarist
diatomite1246023diatomite
diatribe1145673diatribe
diazin1639163diazi_n
diazines1838713diazines
diazins1739183diazins
diazole1736793diazole
dibromide1543553dibromide
dickie133913113dicki_e
didie74120563di_di_e
digamies1238643digamies
digamist1248213digamist
dilative1239523dilative
dime76237643di_m__e
dimity12310473di_mity
dimmed124110323dimmed_
dimming13339593dimming
dimple113512793di_mple
diode74716113di__ode
diopside1245643diopside
diorite8314913diorite
dioxid1568393dioxid_
dioxides1756203dioxides
dioxids1655683dioxids
dirtied93210853dirtied
dislike122913453dislike
disme85716243dism__e
dismiss1038153dismiss
divided13378593di_vided
divider12278953di_vider
divides123211453di_vides
divine103514463di_vine
divvied1544813divvied
dizzied17236133dizzied
domaine10610503domaine
domine92918253d_omine
dopamine1346173dopamine
dormice1237133dormice
dormie9312623dormi_e
dramady1443553dramady
dramedy1433243dramedy
drammed13378073drammed
dualize1759763dualize
dummied13346723dummied
dynamite1444813dynamite
enamine91214313enamine
etamine91313073etamine
examine161510033examine
famine114318193_famine
gamine94620153_gamine
gimmie11298183gimmi_e
halide103417993_halide
imid76122293_i_mid_
imides94515343_i_mides
imido85812243_i_mido
imids86015143_i_mids
imine75821063_i_mine
inside7613453_inside
iodide84812933_iodide
jimmie17376473jimmi_e
jimmied19275033jimmied
lamiae84817453_lamiae
liaise6310693lia_ise
lipide93511063li_pide
mamie95826003_mami_e
mismade12129353mismade
nialamide1252763nialamide
nitride82811243nitride
pismire1135353pismire
ramie75027823_rami_e
riptide1036883riptide
samite83020603_samite
seaside839693seaside
sialid7314943sialid_
sialids839723sialids
siamese936503siamese
simile83115633si_mile
sodamide1245453sodamide
thiamine1346773thiamine
thiazide2143033thiazide
timid84815733ti_mid_
timider1037093ti_mider
titmice1144663titmice
uranide82212093uranide
vitamine1347373vitamine

Search took 8 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 Limit1340271616.75019855.9
3Display Results1611610.0463500.0
 (SQL Overall)1786911617.20224811.3
 
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.