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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
frenchification2872021frenchification
fructification2483674fr_uctification
prenotification2253604prenotification
rectification2049514_re_ctification
denazification29154435_denazification
densification1947335_den_sification
fructifications25113355fr_uctifications
gentrification2065635_gentrification
identification2054995iden_tification
premodification2582975premodification
prettification21115715pre_ttification
preunification2154305pre_unification
recodification22125665_recodification
rectifications2148915_re_ctifications
reification16412905_re___ification
reunification18147455_re_unification
revivification2564225_revivification
sanctification2154705_sanctification
specification2245765spe_c_ification
acetification2046726ace__tification
beatification20138076_be_atification
beautification21144886_beautification
calcification1945826_calc_ification
certification2048606_ce_rtification
cornification2046696corn__ification
dandification2045906_dan_dification
deacidification2472696_deacidification
deification17411666_de___ification
denazifications30164086_denazifications
denitrification21183876_denitrification
densifications2046986_den_sifications
detoxification2754416_detoxification
edification1749356__e__dification
electrification2263416electrification
exemplification3161596exemplification
falsification2145246f__alsification
fortification2196926f__ortification
frenchified2352466frenchif____ied
frenchifies2252866frenchif____ies
frenchifying2751736frenchif___ying
gentrifications2175046_gentrifications
gratification1946686gr__atification
identifications2154496iden_tifications
intensification2092766inten_sification
latensification2071926laten_sification
lignification19125706lign__ification
lithification21105166__lithification
magnification2145766magn__ification
nazification2646046___nazification
nidification1847456___nidification
notification1749066___notification
objectification3181876objectification
pacification2168056__pac_ification
personification2272386personification
petrification2048816_pe_trification
pontification2089016_pon_tification
precipitation1966226pre_c_ipitation
prettifications22135186pre_ttifications
quantification28124936quan_tification
ramification1998216_r__amification
ratification17810666_r__atification
recertification2263986_recertification
recodifications23165456_recodifications
recrimination1757406_re_crimination
refortification2373376_refortification
reifications17411826_re___ifications
reunifications19136916_re_unifications
revivifications2694056_revivifications
rigidification2173146_rigidification
sanctifications2254136_sanctifications
signification1986286sign__ification
silicification2153166silic_ification
specifications2345356spe_c_ifications
unification1648736__un__ification
verification201810646_ve__rification
versification21157496_ve_rsification
vinification2068236_vin__ification

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 Filter178691950240.376475242.0
2DLD Change Limit95024779.26610255.1
3Display Results77770.0631222.2
 (SQL Overall)178691779.70518412.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.