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

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

51 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
valedictories196169(None) 
valedictorian1971292valedictorian
valedictorians2071082valedictorians
calefactories2062503calefactories
valedictory2051743valedictor__y
auditories1146214_a_udi_tories
maledictory1962094maledictor__y
valediction1752404valedict__ion
valedictions1852224valedict_ions
validities1447304validi_t__ies
vanitories1346914va__ni_tories
vasectomies1854514vase__ctomies
victories1448924v____ictories
abductores1551995_a_bductor_es
albicores1343525_al_bic_or_es
antistories1149385_a_ntistories
banditries1345345ba_ndi_t_ries
clearstories1472345_clearstories
clerestories1453315_clerestories
colectomies1756775cole__ctomies
directories1446025dire__ctories
factories14810115fa____ctories
judicatories2251835__judicatories
maledicted1642545maledict___ed
maledicting1752725maledict__ing
malediction1653115maledict__ion
maledictions1752955maledict_ions
maledicts1443395maledict____s
malefactors1852695malefactor__s
mandatories1454975ma_nd_atories
manufactories20112735manufactories
masticatories1762205ma_sticatories
olfactories1653565_ol_factories
paediatrics1652635pa_ediat_rics
palmistries1593765pal_mist_ries
pellitories1354845pel_li_tories
predictors1547265_predictor__s
prehistories1755345_prehistories
rectories11314665__re__ctories
refectories1646435__refectories
salutatories1262325sal_utatories
splenectomies1973165splenectomies
stapedectomies2181845stapedectomies
trajectories2163635traje__ctories
valencies1446415vale_nc___ies
valetudinaries1871245valetudi_naries
vapidities1646385vapidi_t__ies
varletries1346035varle___t_ries
vasectomizes2853395vase__ctomizes
victorias1446525v____ictorias
vomitories1544905v__omi_tories

Search took 10 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.390458182.1
2DLD Change Limit124790518.95313938.3
3Display Results51510.0301700.0
 (SQL Overall)178691519.37319064.4
 
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.