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

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

194 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
ratification1781066(None) 
gratification1946681gratification
ramification1998211ramification
ratifications1899781ratifications
basification19127322basification
beatification20138072beatification
citification1949152citification
gasification1867102gasification
gratifications2045982gratifications
nazification2646042nazification
notification1749062notification
pacification2168052pacification
ramifications2087532ramifications
rectification2049512rectification
reification16412902r_eification
stratification1954672stratification
acetification2046723acetification
basifications20137063basifications
beatifications21157463beatifications
beautification21144883beautification
calcification1945823calcification
caprification2256053caprification
certification2048603certification
citifications2048543citifications
clarification2045763clarification
coalification2046133coalification
codification20108073codification
dandification2045903dandification
deification17411663_deification
edification1749353_edification
falsification2145243falsification
fortification2196923fortification
fructification2483673fructification
gasifications19116843gasifications
humification2246103humification
justification2546093justification
latinization21139523latinization
lithification21105163lithification
magnification2145763magnification
modification20107203modification
mortification2087293mortification
mystification2346193mystification
nazifications2745523nazifications
nidification1847453nidification
nitrification1877063nitrification
notifications1848233notifications
ossification17116543ossification
pacifications2267353pacifications
petrification2048813petrification
pontification2089013pontification
prettification21115713prettification
purification1948173purification
qualification2745033qualification
quantification28124933quantification
ratiocination1574323ratiocination
rectifications2148913rectifications
reifications17411823r_eifications
reunification18147453reunification
sanctification2154703sanctification
scarification2056403scarification
stratifications2054233stratifications
typification2244863typification
uglification1845493uglification
unification1648733_unification
vaticination1745763vaticination
verification201810643verification
vilification2077123vilification
vinification2068233vinification
vitrification2166463vitrification
vivification2366343vivification
abdication1548224_a_bdication
acetifications2146054acetifications
acidification2154884acidification
affixation2344394_a_ffixation
amplification2275184amplification
anticipation1668284anticipation
antifriction1773984antifric_tion
application1747474_application
arabicization2654084arabicization
articulation1447974articulation
atomization2249244_atomization
beautifications22154684beautifications
calcifications2045414calcifications
caprifications2385564caprifications
certifications2147794certifications
clarifications2155264clarifications
classification21113214classification
coalifications2155704coalifications
codifications21127624codifications
cornification2046694cornification
dandifications2145434dandifications
deifications18410654_deifications
denazification29154434denazification
densification1947334densification
detoxication2246204detoxication
detoxification2754414detoxification
edifications1848694_edifications
eradication14410114era__dication
eroticization2476034eroticization
esterification1995334esterification
extrication2049794ext_rication
fabrication1846604fa_brication
facilitation1746574facilitation
falsifications2244974falsifications
fortifications2286214fortifications
fructifications25113354fructifications
gentrification2065634gentrification
glorification1984894glorification
habilitation1795514habilitation
humifications2345854humifications
identification2054994identification
intimidation1547364intimidation
intoxication21156354intoxication
jollification25134844jollification
justifications2645554justifications
keratinization2754004keratinization
laciniation1346634lacini_ation
laicization2247904la_icization
latensification2071924latensification
laterization21410684laterization
latinizations22159014latinizations
lignification19125704lignification
lithifications22134794lithifications
magnifications2245114magnifications
mastication15610294ma_stication
maximization3255214maximization
metafiction1852844metafic_tion
metrication15410654met_rication
modifications21106984modifications
mollification20135554mollification
mortifications2186504mortifications
mummification2154314mummification
mystifications2445644mystifications
nidifications1946944nidifications
nitrifications1986634nitrifications
nullification1854694nullification
optimisation16193944optimisation
optimization25166464optimization
ossifications18176144ossifications
pacificator2053544pacificat_or
participation1955254participation
patination12312574pat__ination
petrifications2148024petrifications
pontifications2187924pontifications
prenotification2253604prenotification
prettifications22135184prettifications
preunification2154304preunification
purifications2047464purifications
qualifications2844584qualifications
quantifications29114404quantifications
racemization2565964racemization
radiation10313394ra__di_ation
rarefaction1652654rarefac_tion
ratiocinations1674134ratiocinations
reapplication1954724reapplication
recertification2263984recertification
recodification22125664recodification
rededication1646504rededication
refortification2373374refortification
replication15712014r_eplication
retaliation11612324retali_ation
reticulation1448054reticulation
reunifications19136914reunifications
reutilization2249194reutilization
revivification2564224revivification
rigidification2173144rigidification
routinization2255834routinization
rubrication1547124r_ubrication
rustication1349224r_ustication
salinization2158894salinization
sanctifications2254134sanctifications
sanitization2149154sanitization
saponification21103534saponification
satiation9313434sat__i_ation
satisfaction17142114satisfac_tion
scarifications2155764scarifications
signification1986284signification
specification2245764specification
stultification1963904stultification
titivation1347034__titivation
typifications2344634typifications
uglifications1945194uglifications
umbilication1884744umbilication
unifications1748044_unifications
urtication1249114urt__ication
utilization2049684_utilization
vaticinations1845034vaticinations
verifications21159974verifications
versification21157494versification
vilifications2166744vilifications
vinifications2177694vinifications
vitrifications2275964vitrifications
vivifications2486124vivifications
zombification3154064zombification

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.390458182.1
2DLD Change Limit1247901946.46619299.4
3Display Results1941940.1261539.7
 (SQL Overall)1786911946.98225593.1
 
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.