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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
indemnification2372001indemnification_
identification2054994i_dentification_
identifications2154494i_dentifications
intensification2092764intensification_
deification17411665__de__ification_
deifications18410655__de__ifications
densification1947335__densification_
densifications2046985__densifications
nidification1847455nid___ification_
nidifications1946945nid___ifications
preunification2154305_preunification_
reunification18147455__reunification_
reunifications19136915__reunifications
acetification2046726_ace_tification_
acetifications2146056_ace_tifications
ammonification2353046_ammonification_
ammonifications2453046_ammonifications
beatification20138076__beatification_
beatifications21157466__beatifications
certification2048606__certification_
certifications2147796__certifications
codification20108076cod___ification_
codifications21127626cod___ifications
cornification2046696__cornification_
cornifications2145956__cornifications
dandification2045906__dandification_
dandifications2145436__dandifications
decertification2364326decertification_
demystification26102696__demystification_
denazification29154436__denazification_
denazifications30164086__denazifications
desertification2154126desertification_
detoxification2754416__detoxification_
detoxifications2884256__detoxifications
diversification24102786diversification_
edification1749356___e_dification_
edifications1848696___e_difications
esterification1995336este_rification_
esterifications20134816este_rifications
exemplification3161596_exemplification_
humification2246106__hum_ification_
humifications2345856__hum_ifications
indemnifying2261546indemnif___yi_ng
indentation1248376inde_n___tation_
indentations1347886inde_n___tations
indetermination1863136indetermination_
indication13312036ind_____ication_
indicational1545756ind_____icational
indications14310976ind_____ications
insemination1446996insem___ination_
inseminations1546246insem___inations
interdigitation1763146interdigitation_
internalization2455766internalization_
intervisitation1862856intervisitation_
latensification2071926latensification_
lignification19125706__lignification_
lignifications20135116__lignifications
magnification2145766__magnification_
magnifications2245116__magnifications
modification20107206mod___ification_
modifications21106986mod___ifications
mummification2154316__mummification_
mummifications2254016__mummifications
nazification2646046_n__azification_
nazifications2745526_n__azifications
nitrification1877066_n_itrification_
nitrifications1986636_n_itrifications
notification1749066_n__otification_
notifications1848236_n__otifications
nullification1854696_n_ullification_
nullifications1954306_n_ullifications
objectification3181876objectification_
personification2272386personification_
petrification2048816__petrification_
petrifications2148026__petrifications
premodification2582976_premodification_
prettification21115716_prettification_
prettifications22135186_prettifications
ramification1998216__ram_ification_
ramifications2087536__ram_ifications
recertification2263986recertification_
rectification2049516__rectification_
rectifications2148916__rectifications
reification16412906__re__ification_
reifications17411826__re__ifications
saponification21103536_saponification_
saponifications22133326_saponifications
signification1986286__signification_
significations20125676__significations
specification2245766_spe_cification_
specifications2345356_spe_cifications
underinflation1862386underinf_lation_
underinflations1962326underinf_lations
unification1648736____unification_
unifications1748046____unifications
verification201810646__ve_rification_
verifications21159976__ve_rifications
versification21157496__versification_
versifications22166916__versifications
vinification2068236___vinification_
vinifications2177696___vinifications
zombification3154066__zombification_
zombifications3263766__zombifications

Search took 6 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 Filter178691658740.356501941.0
2DLD Change Limit658741035.01613132.8
3Display Results1031030.0801287.5
 (SQL Overall)1786911035.45232775.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.