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

101 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
electrification226340(None) 
gentrification2065633_gentrification
petrification2048813_pe_trification
rectification2049513_rect_ification
acetification2046724ace_t_ification
beatification20138074_beat_ification
certification2048604_cert_ification
clarification2045764cl__arification
decertification2364324_decertification
denitrification21183874denitrification
desertification2154124desert_ification
devitrification24133504devitrification
electrocution1763374electr__ocution
esterification1995324e_sterification
exemplification3161594exemplification
fructification2483674fruct_ification
gentrifications2175044_gentrifications
glorification1984894gl__orification
identification2054994ident_ification
lithification21105164_l_ithification
nitrification1877064__nitrification
objectification3181874object_ification
petrifications2148024_pe_trifications
prettification21115714pre_ttification
recertification2263984_recertification
recodification22125664_recodification
rectifications2148914_rect_ifications
sanctification2154704sanct_ification
scarification2056404__scarification
specification2245764spec__ification
verification201810644_ve__rification
vitrification2166464__vitrification
acetifications2146055ace_t_ifications
acidification2154885__acidification
beatifications21157465_beat_ifications
beautification21144885_beautification
calcification1945825calc__ification
caprification2256055__caprification
centrifugation2061715_centrifugation
certifications2147795_cert_ifications
citification1949155___citification
clarifications2155265cl__arifications
classification21113215cl_assification
codification20108075___codification
cornification2046695___cornification
deacidification2472695deacidification
decalcification2262805_decalcification
decortication1857535_decor_tication
deification17411665_de___ification
demystification26102695demyst_ification
denazification29154435_denazification
densification1947335_de_nsification
detoxification2754415_detoxification
edification1749355__e__dification
electrician1554475electr__ic__ian
electricities1755215electr__icities
electrocutions1863005electr__ocutions
elutriation1146715el_utr__i_ation
emulsification2193445e_mulsification
esterifications20134805e_sterifications
extrication2049795__extr__ication
fortification2196925_fort_ification
frenchification2872025frenchification
fructifications25113355fruct_ifications
glorifications2074575gl__orifications
gratification1946685_grat_ification
identifications2154495ident_ifications
justification2546095_just_ification
lignification19125705_l_ignification
lithifications22134795_l_ithifications
metrication15410655_me_tr__ication
mortification2087295_mort_ification
mystification2346185_myst_ification
nitrifications1986625__nitrifications
notification1749065__not_ification
pacification2168055_pac__ification
petrifaction1953725_pe_trifac_tion
pontification2089005_pont_ification
premodification2582975premodification
prenotification2253605prenotification
prettifications22135185pre_ttifications
preunification2154305pre_unification
purification1948175___purification
quantification28124935quant_ification
ratification17810665__rat_ification
recodifications23165455_recodifications
recrimination1757405_rec_rimination
refortification2373375_refortification
reification16412905_re___ification
reunification18147455_re_unification
revivification2564225_revivification
sanctifications2254135sanct_ifications
scarifications2155765__scarifications
securitization2554305_securitization
silicification2153165silic__ification
specifications2345355spec__ifications
stratification1954675strat_ification
stultification1963905stult_ification
verifications21159965_ve__rifications
versification21157495_ve_rsification
vitrifications2275955__vitrifications

Search took 5 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.0931921408.6
2DLD Change Limit658741014.15615850.3
3Display Results1011010.0761328.9
 (SQL Overall)1786911014.32541315.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.