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 “certificating” 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.

177 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
certificating215364(None) 
certification2048602certification
certifications2147792certifications
certificate18112973certificat__e
certificated20112603certificat_ed
certificates1992903certificat_es
certificatory2362013certificatory
pontificating2153773pontificating
acetification2046724ace_tification
acetifications2146054ace_tifications
beatification20138074beatification
beatifications21157464beatifications
certifying1945314certif___ying
citification1949154c_itification
citifications2048544c_itifications
cornification2046694cornification
cornifications2145954cornifications
criminating1646854c_r_iminating
decertification2364324decertification
detoxicating2353864de_toxicating
eradicating1556634_er_adicating
extricating2146694_ext_ricating
fortification2196924fortification
fortifications2286214fortifications
metricating1647364me_t_ricating
mortification2087294mortification
mortifications2186504mortifications
participating2053374participating
petrification2048814petrification
petrifications2148024petrifications
recertification2263984recertification
rectification2049514rectification
rectifications2148914rectifications
urticating1347354_urt__icating
verification201810644ver_ification
verifications21159974ver_ifications
versification21157494versification
versifications22166914versifications
aestivating1545805aest__ivating
anticipating1756265_anticipating
articulating1556765_articulating
beautification21144885beautification
beautifications22154685beautifications
beneficiating2161455be_neficiating
busticating1645305bust__icating
calcification1945825calcification
calcifications2045415calcifications
cantillating1565055canti_llating
caprification2256055caprification
caprifications2385565caprifications
captivating1944885capt__ivating
castigating1546005cast__igating
cerebrating1646665cer__ebrating
certifiable1852915certifi_a_ble
certifiably2152555certifi_a_bly
clarification2045765clarification
clarifications2155265clarifications
coalification2046135coalification
coalifications2155705coalifications
codification20108075c_odification
codifications21127625c_odifications
communicating2254875communicating
complicating2145635c_omplicating
conciliating1775625concili_ating
confiscating2053615confi_scating
contaminating1854915contaminating
coruscating1644695cor__uscating
crepitating1645805c_r_epitating
criticising1653425c_r_iticising
criticizing2554535c_r_iticizing
cultivating1744945cult__ivating
debilitating1654115de_bilitating
decorticating1984245decorticating
dedicating1539145de___dicating
defecating17237785de___fecating
deification17411665de__ification
deifications18410655de__ifications
densification1947335densification
densifications2046985densifications
deracinating1645225der_acinating
desertification2154125desertification
desiccating1744705de_si_ccating
edification1749355_e_dification
edifications1848695_e_difications
eliminating1445545_e_liminating
equivocating2751715_equivocating
eradiating1248735_er_adi_ating
estimating1348885_est__imating
estivating1447635_est__ivating
etiolating1146985_e_ti_olating
explicating2356125_e_xplicating
exsiccating2342665_exsi_ccating
extincting2044005_exti_nc_ting
extirpating2143745_exti_rpating
felicitating1853325fe_licitating
fertilization2588455fertilization
fertilizations26137895fertilizations
fertilizing2446455fertili__zing
festinating1547375fest__inating
fornicating1774875for__nicating
gentrification2065635gentrification
gentrifications2175045gentrifications
germinating1546175ger__minating
gesticulating1773945gesticulating
gratification1946685gratification
gratifications2045985gratifications
herniating1445985her__ni_ating
identification2054995identification
identifications2154495identifications
intimidating1654745_intimidating
intoxicating2254125_intoxicating
justification2546095justification
justifications2645555justifications
justificative2861405justificative
legitimating1653815le_gitimating
masticating1647835mast__icating
medicating1648955me___dicating
mystification2346195mystification
mystifications2445645mystifications
nitrification1877065nitrification
nitrifications1986635nitrifications
notification1749065_notification
notifications1848235_notifications
originating1344905_or_iginating
overmedicating2363015overmedicating
peregrinating1752975peregrinating
perfecting1847515per__fec_ting
perforating1747025per__forating
pontification2089015pontification
pontifications2187925pontifications
precipitating2074035precipitating
predicating1749655_pr_edicating
prettification21115715prettification
prettifications22135185prettifications
prevaricating2153075prevaricating
purification1948175pur_ification
purifications2047465pur_ifications
radicating1459075__r_adicating
ratification17810665_ratification
ratifications1899785_ratifications
rearticulating1753695rearticulating
recriminating1864935recriminating
rededicating1744335re_dedicating
reduplicating1953505reduplicating
refortification2373375refortification
reification16412905__reification
reifications17411825__reifications
reinitiating1345765reiniti_ating
relubricating1863095relubricating
replicating1649095__replicating
reradiating1347265rer_adi_ating
restimulating1654135restimulating
restricting1449305rest_ric_ting
retaliating1248875re_tali_ating
reticulating1546395re_ticulating
retrodicting1654465retrodic_ting
retrofitting1653185retrofi_tting
reunification18147455reunification
reunifications19136915reunifications
rubricating1645105__rubricating
rusticating1446315__rusticating
scarification2056405scar_ification
scarifications2155765scar_ifications
seriating10916405ser___i_ating
sextuplicating2661515sextuplicating
stratification1954675stratification
stratifications2054235stratifications
terminating1447355ter__minating
titivating1445325___titivating
trifurcating1852145_tr_ifurcating
triplicating1753825_triplicating
vaticinating1853565_vaticinating
vellicating1744565ve__llicating
ventilating1546345vent__ilating
vesicating1646905ve___sicating
vitrification2166465vitrification
vitrifications2275965vitrifications

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.423422437.4
2DLD Change Limit1247901779.06313769.2
3Display Results1771770.1101609.1
 (SQL Overall)1786911779.59618621.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.