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

60 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
centrifugations2161481centrifugations_
centrifugation2061712centrifugation__
gentrifications2175044gentrifications_
centralizations26157785centralizations_
centrifugals1871505centrifuga___ls_
centrifuging1951855centrifug__i_n_g
certifications2147795cert_ifications_
continuations1547155cont_inu_ations_
contributions1754745contribu__tions_
denticulations1753915dent_iculations_
gentrification2065635gentrification__
petrifications2148025pe_trifications_
acetifications2146056ace_t_ifications_
antiquations2146246_ant_iqu_ations_
beatifications21157466beat_ifications_
cantillations1545736cant_i_llations_
caprifications2385566c_aprifications_
castigations1547206cast_i__gations_
centralization25108156centralization__
centrifugal1761996centrifuga_____l
centrifugally2281556centrifuga___lly
centrifuges1752876centrifug____es_
certification2048606cert_ification__
citifications2048546c_it_ifications_
clarifications2155266c_larifications_
configurations2063706con_figurations_
confutations1767796con___futations_
congratulations1882786congratulations_
congregations17186416congr__egations_
conjugations2245866con___jugations_
continuation1448196cont_inu_ation__
contribution1655096contribu__tion__
contritions13410916contri____tions_
corrugations1565486c__or_rugations_
denazifications30164086denazifications_
denitrification21183876denitrification__
densifications2046986den_sifications_
denticulation1654566dent_iculation__
esterifications20134816_esterifications_
extrications2149056_extri__cations_
gesticulations1784116gest_iculations_
identifications2154496ident_ifications_
matriculations18144786_matriculations_
menstruations1585056menstr__u_ations_
metrications1649836me_tri__cations_
nitrifications1986636_nitrifications_
petrifactions2083566pe_trif_actions_
petrification2048816pe_trification__
pontifications2187926pont_ifications_
rectifications2148916rect_ifications_
restimulations1654646rest_imulations_
reticulations1556616re_t_iculations_
retributions14134946re_tribu__tions_
stridulations1454406__stridulations_
tribulations1445466___tribulations_
trifurcations1852866___trifurcations_
triturations1245686___triturations_
ventilations1547406vent_i__lations_
verifications21159976ve__rifications_
vitrifications2275966_vitrifications_

Search took 6 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.330541487.9
2DLD Change Limit65874605.28012476.1
3Display Results60600.0461304.3
 (SQL Overall)178691605.65631593.2
 
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.