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

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

71 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
preformulating228187(None) 
reformulating1972821_reformulating
formulating1765053___formulating
preformatting2152073preform_atting
preformulate1952383preformulat__e
preformulated2162033preformulat_ed
preformulates2062223preformulat_es
reformulation1853973_reformulation
reformulations1953553_reformulations
perforating1747024perfor___ating
predominating1964344predo_minating
preformation1946474preform__ation
preformations2045714preform__ations
preforming1846234preform____ing
prenominating1854694preno_minating
promulgating1852294pr__o_mulgating
recirculating1853534_recirculating
reformatting1852704_reform_atting
reformulate1653024_reformulat__e
reformulated1852764_reformulat_ed
reformulates1752984_reformulat_es
repopulating1744484_repo_pulating
restimulating1654134_restimulating
deformalizing2954225_deformalizing
demodulating1753165_demo_dulating
depopulating1853735_depo_pulating
emulating1239875__e___mulating
formulation1646365___formulation
formulations1745645___formulations
formulizing2643655___formulizing
peculating1549165p_e___culating
perambulating2052525p_erambulating
percolating1657325p_e__rcolating
performative22103875perform__ative
performing1844945perform____ing
permeating1539925p_e__rm_eating
permuting1446555p_e__rmu__ting
perorating13313135p_eror___ating
phenolating1745255pheno___lating
populating1547665p___o_pulating
postulating1447505p___ostulating
precomputing2153275preco_m_puting
prefabricating2461735prefabricating
prefocusing1953135prefo_cu__sing
prefocussing2052345prefo_cu_ssing
preformat1646365preform__at___
preformats1744415preform__at__s
preformatted2052275preform__atted
prelocating1647415prelo___cating
preponderating2062585preponderating
presorting1339985presor____ting
pretermitting1852555preterm_itting
pretreating1448895pre_tr__eating
prevaricating2153075prevar_icating
promulging1642685pr__o_mul_ging
prorating12314285pr__or___ating
prorogating1556065pr__or_ogating
recalculating1853645_recalculating
reconsulting1554215_reconsul_ting
reflating132514715_ref____lating
reforesting1546195_refor__esting
reformation1648415_reform__ation
reformations1747605_reform__ations
reformative1945675_reform__ative
reforming1538565_reform____ing
regulating12310065_re___gulating
reinoculating1653585_reinoculating
renominating1546425_reno_minating
reregulating1454645_re_regulating
reticulating1546395_re_ticulating
sporulating1445115__spor_ulating

Search took 7 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.360496363.9
2DLD Change Limit95024716.37614903.4
3Display Results71710.0431651.2
 (SQL Overall)178691716.77926359.5
 
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.