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

127 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
dedication1431196(None) 
dedications15310871dedications
medication15411171medication
abdication1548222abdication
decimation15411622decimation
dedicating1539142dedicating
dedicator1348252dedicat_or
deduction1377082deduc_tion
defecation1679802defecation
deification17411662deification
depiction1437272depic_tion
depilation13312032depilation
derivation14712782derivation
desiccation1646382desiccation
deviation13312392devi_ation
education12310202_education
indication13312032indication
mediation12312292medi_ation
medications1649932medications
meditation13410742meditation
predication16412432predication
rededication1646502rededication
abdications1657653abdications
addiction13146013addic_tion
adjudication2352443adjudication
coeducation1646233coeducation
deaeration11313013deaeration
dealation10313003de_alation
deamination14411543deamination
decimations16410163decimations
declination14411873declination
decoction1447523decoc_tion
decoration13314423decoration
dedicate12312803dedicat__e
dedicated14310253dedicat_ed
dedicatee13410343dedicat_ee
dedicatees1445313dedicatees
dedicates13311693dedicat_es
dedicators1447743dedicators
dedicatory1745673dedicatory
deductions1467133deduc_tions
defalcation1746223defalcation
defamation1646843defamation
defecations1779003defecations
defection151610643defec_tion
definition1445963definition
deflation13310653de_flation
deifications18410653deifications
dejection19178663dejec_tion
delation92318083de__lation
delectation1448553delectation
delegation1238883delegation
delineation1247763delineation
demarcation1647023demarcation
denegation1249413denegation
denigration1348463denigration
denotation11311083denotation
dentation10315243de_ntation
denudation1247303denudation
deoxidation2045953deoxidation
depictions1546893depic_tions
depilations14310903depilations
deprecation1648963deprecation
deprivation1788773deprivation
deputation1339393deputation
derivations15611493derivations
derogation12410393derogation
desecration14410073desecration
desiccations1755653desiccations
designation1347483designation
desolation11311403desolation
destination12413843destination
detection121310413detec_tion
detonation11310943detonation
detoxication2246203detoxication
detraction13138583detraction
deviations14311163devi_ations
dictation12810563__dictation
diction102313053__dic_tion
dilation92215463__dilation
divination14139233divination
domination13712373domination
dubitation1377333dubitation
duplication1647293duplication
edification1749353edification
edition8310853_edi__tion
educations1339233_educations
eduction1169053_educ_tion
epilation11312963_epilation
eradication14410113eradication
eviction13228683_evic_tion
evocation142010293_evocation
federation1449573federation
gemination131410653gemination
hesitation1349633hesitation
indications14310973indications
indiction1239813indic_tion
iodination1159983iodination
levigation1447023levigation
levitation1349443levitation
mediations13310983medi_ations
medicating1648953medicating
meditations1449333meditations
metrication15410653metrication
ordination1149413ordination
plication13311683_plication
predications17411183predications
prediction15410303predic_tion
radiation10313393radi_ation
recitation12315943recitation
redaction1259663redac_tion
rededications1746123rededications
reduction1259903reduc_tion
reeducation1445933reeducation
reification16412903reification
reliction11310693relic_tion
relocation12312113relocation
replication15712013replication
revocation15410813revocation
sedation9312453sed__ation
sedition939333sedi__tion
seduction1266983seduc_tion
seriation9318063seri_ation
sonication12411183sonication
syndication17124963syndication
urtication1249113urtication
vindication1746353vindication

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031275.53025425.5
3Display Results1271270.0632015.9
 (SQL Overall)1786911276.01629702.6
 
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.