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 “benedictions” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
benedictions175324(None) 
benediction1643321benediction_
benefactions1952692benefactions
benedictory1952083benedict_ory
benedicts1443573benedict___s
benefaction1852823benefaction_
beneficiations21182213beneficiations
derelictions1544333derelictions
indictions1339313_in_dictions
maledictions1752953maledictions
predictions1649653_predictions
rededications1746123rededications
reeditions1147653re_edi_tions
remediations1548273remediations
renditions1149183ren_di_tions
valedictions1852223valedictions
venditions1445523ven_di_tions
venesections1752933venesections
addictions14125364__addictions
benedicks1842564benedic___ks
benedict1346424benedict____
benefactors1852544benefact_ors
beneficiation20162554beneficiation_
beneficing1843824benefic_i_ng
benefiting1644314benefi_ti_ng
benefitting1752854benefitti_ng
bijections21134934bije__ctions
bilections14136504bile__ctions
bisections14136734bise__ctions
bolections14137294bole__ctions
conditions13410104con_di_tions
conductions1649664con_ductions
conflictions1945224conflictions
convictions1848054con_victions
dedications15310874__dedications
deductions1467134__deductions
defections161510204defe__ctions
dejections20168354deje__ctions
denegations1348544dene_gations
denervations1657094denervations
dentitions1148854den_ti_tions
denudations1346344denud_ations
depictions1546894__depictions
dereliction1444574dereliction_
detections131410044dete__ctions
dictions111812674____dictions
editions9310404___edi_tions
eductions1268774___eductions
ejections18249964_eje__ctions
elections112414974_ele__ctions
enervations1478574_enervations
eradications1549304_eradications
erections112515214_ere__ctions
eruditions1146104_erudi_tions
evections142510694_eve__ctions
evictions14228624___evictions
expeditions2144634expedi_tions
generations12311424gene_rations
indications14310974_in_dications
indiction1239814_in_diction_
inductions1348804_in_ductions
inflictions1645444_inflictions
interdictions1667494interdictions
lenitions939474len__i_tions
malediction1653114malediction_
mediations13310984__mediations
medications1649934__medications
metafictions1952654metafictions
nonelections1456394nonelections
nonfictions1645934non_fictions
penetrations1448854penetrations
perditions1348874pe_rdi_tions
predications17411184_predications
prediction15410304_prediction_
redactions1359134__redactions
rededication1646504rededication_
reductions1359584__reductions
reedition1047834re_edi_tion_
reeducations1545474re_educations
reelections13167944re_elections
refections151811644refe__ctions
rejections191510104reje__ctions
relictions12310024__relictions
remediation1449214remediation_
rendition1058934ren_di_tion_
repetitions1378024repeti_tions
repudiations1597034repudiations
reradiations1349494reradiations
resections121513034rese__ctions
restrictions1449284restrictions
retrodictions1655534retrodictions
seditions1039014__sedi_tions
seductions1366874__seductions
selections12310874sele__ctions
syndications18104474syn_dications
valediction1752404valediction_
vendition1345694ven_di_tion_
venerations14411314vene_rations
venesection1652944venesection_
vindications1845684vin_dications

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 Filter1786911247900.420425454.8
2DLD Change Limit1247901007.26617174.5
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.73223110.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.