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

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

193 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
identification205499(None) 
identifications2154491identifications
densification1947332_densification
acetification2046723ace_tification
beatification20138073_beatification
certification2048603_certification
dandification2045903_dandification
deification17411663_de__ification
denazification29154433_denazification
denitrification21183873_denitrification
densifications2046983_densifications
gentrification2065633_gentrification
indemnification2372003indemnification
intensification2092763intensification
pontification2089003_pontification
prenotification2253603prenotification
prettification21115713prettification
quantification28124933quantification
rectification2049513_rectification
acetifications2146054ace_tifications
beatifications21157464_beatifications
beautification21144884beautification
certifications2147794_certifications
citification1949154__citification
cornification2046694corn_ification
dandifications2145434_dandifications
decertification2364324decertification
deifications18410654_de__ifications
demystification26102694_demystification
denazifications30164084_denazifications
denticulation1654564_denticulation
desertification2154124desertification
detoxication2246204_de_toxication
detoxification2754414_detoxification
devitrification24133504_devitrification
diversification24102784diversification
edification1749354__e_dification
electrification2263414electrification
fortification2196924_fortification
frenchification2872024frenchification
fructification2483674fructification
gentrifications2175044_gentrifications
gratification1946684_gratification
intimidation1547364i__ntimidation
intoxication21156354i__ntoxication
justification2546094_justification
latensification2071924latensification
lignification19125704lign_ification
magnification2145764magn_ification
mortification2087294_mortification
mystification2346194_mystification
nidification1847444nid___ification
notification1749064__notification
objectification3181874objectification
petrification2048814_petrification
pontifications2187914_pontifications
prettifications22135184prettifications
preunification2154304preunification
quantifications29114404quantifications
ratification17810664__ratification
recertification2263984recertification
rectifications2148914_rectifications
reification16412904_re__ification
reunification18147454_reunification
sanctification2154704sanctification
signification1986284sign_ification
specification2245764spe_cification
stratification1954674stratification
stultification1963904stultification
unification1648734__un_ification
verification201810644_ve_rification
versification21157494_versification
vinification2068234_vin_ification
acidification2154885_acidification
ammonification2353045ammonification
amplification2275185_amplification
anticipation1668285__anticipation
antifriction1773985__antifric_tion
basification19127325__basification
beautifications22154685beautifications
beneficiation20162555_ben_eficiation
calcification1945825_calcification
caprification2256055_caprification
centrifugation2061715_centrifugation
certificating2153645_certificating
citifications2048545__citifications
clarification2045765_clarification
classification21113215classification
coalification2046135_coalification
codification20108075__codification
cornifications2145955corn_ifications
deacidification2472695_deacidification
debilitation1547785_de_bilitation
decalcification2262805_decalcification
decortication1857535_decortication
dedication14311965_de___dication
defecation1679805_de___fecation
delimitation1597265_de_limitation
denigration1348465_den_i_gration
denomination15118835_den_omination
dentation10315245_dent____ation
denticulations1753915_denticulations
dentition1049635_dent__i__tion
denunciation1554535_denunci_ation
desiccation1646385_de_si_ccation
destination12413845_dest__ination
detoxications2355655_de_toxications
detoxifications2884255_detoxifications
disintoxication2572555disintoxication
edifications1848695__e_difications
emulsification2193445emulsification
esterification1995335esterification
exemplification3161595exemplification
extrication2049795__ext_rication
falsification2145245_falsification
fertilization2588455_fertilization
fortifications2286215_fortifications
fructifications25113355fructifications
gasification1867105__gasification
glorification1984895_glorification
gratifications2045985_gratifications
humidification2552905humidification
humification2246105__humification
idealization22410275ide__alization
identifiable1882145identifi_a_ble
identifiably2192005identifi_a_bly
indentation1248375indent____ation
indication13312035i__n__dication
infantilization2762035infantilization
infixation2047535i__n__fixation
initiation10412105i__n_iti_ation
intimation12413045i__nt__imation
intimidations1686665i__ntimidations
intinction1247785i__nti_nc_tion
intoxications22135685i__ntoxications
invigilation1655145i__nvigilation
jollification25134845_jollification
justifications2645555_justifications
lignifications20135115lign_ifications
lithification21105165_lithification
magnifications2245115magn_ifications
metafiction1852845_me_tafic_tion
metrication15410655_me_t_rication
modification20107205__modification
mollification20135555_mollification
mortifications2186505_mortifications
mummification2154315_mummification
mystifications2445645_mystifications
nazification2646045__nazification
nidifications1946935nid___ifications
nitrification1877065_nitrification
notifications1848235__notifications
nullification1854695_nullification
ossification17116545__ossification
pacification2168055__pacification
petrifications2148025_petrifications
pontificating2153765_pontificating
pontificator1953465_pontificat_or
premodification2582975premodification
purification1948175__purification
qualification2745035_qualification
ramification1998215__ramification
ratifications1899785__ratifications
recodification22125665recodification
refortification2373375refortification
reifications17411825_re__ifications
reunifications19136915_reunifications
reutilization2249195_reutilization
revivification2564225revivification
rigidification2173145rigidification
sanctifications2254135sanctifications
saponification21103535saponification
scarification2056405_scarification
sensitisation13153645_sensitisation
sensitization22146725_sensitization
significations20125675sign_ifications
silicification2153165silicification
simplification2353385simplification
solidification2053555solidification
specifications2345355spe_cifications
stratifications2054235stratifications
stultifications2083535stultifications
typification2244865__typification
uglification1845495__uglification
unifications1748045__un_ifications
ventilation1448165_vent__ilation
verifications21159975_ve_rifications
versifications22166915_versifications
vilification2077125__vilification
vinifications2177695_vin_ifications
vitrification2166465_vitrification
vivification2366345__vivification
zombification3154065_zombification

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 Filter178691950240.1231452772.4
2DLD Change Limit950241937.36012910.9
3Display Results1931930.1401378.6
 (SQL Overall)1786911937.62323441.0
 
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.