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

170 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
preformatting215207(None) 
reformatting1852701_reformatting
formatting1644163___formatting
perforating1747023perfor_a_ting
preformation1946473preforma_tion
preformations2045713preformations
preformatted2052273preformatt_ed
preforming1846233preform___ing
preformulating2281873preformulating
pretermitting1852553pretermitting
performative22103874performa_tive
performing1844944perform___ing
permitting1546304p_e__rmitting
perorating13313134p_eror_a_ting
preadmitting1852764pre_admitting
precomputing2153274preco_mputing
preformat1646364preforma_t___
preformats1744414preforma_t__s
prefranking2143314pref_r_anking
prelocating1647414prelo_ca_ting
preordaining1652514pre_ordaining
presorting1339984presor___ting
pretreating1448894pre_trea_ting
prorating12314284pr__or_a_ting
recommitting1954134_recommitting
reforesting1546194_refor_esting
reformation1648414_reforma_tion
reformations1747604_reformations
reformative1945674_reforma_tive
reformatted1752624_reformatt_ed
reforming1538564_reform___ing
reformulating1972824_reformulating
refracting1638734_ref_r_acting
befretting1644795_bef_r_etting
bromating1439175br__o_ma_ting
cremating14312195cre___ma_ting
decorating14312075_decor_a_ting
defatting1436105_def___atting
defoliating1645825_defolia_ting
deforesting1654795_defor_esting
deformalizing2954225_deformalizing
deformation1747665_deforma_tion
deformations1846845_deformations
deformative2044975_deforma_tive
deforming1636705_deform___ing
deratting1139515_de__r_atting
forgetting1544665___forgetting
formfitting2051895___formfitting
intermatting1547175_intermatting
percolating1657325perco_la_ting
perforation1649005perfor_a_tion
perforations1747875perfor_ations
performatives2392685performatives
performatory2252585performa_tory
permeating1539925p_e__rmeating
permuting1446555p_e__rm_uting
personating1447675perso_na_ting
phenolating1745255pheno_la_ting
photostatting1993375photostatting
preacting142412535pre____acting
preadapting1743655pre__adapting
preallotting1551995pre_allotting
prearming14139225pre_arm___ing
prearranging1652655pre_arranging
preboarding1744275prebo__arding
precasting15169835pre___casting
precipitating2074035precipitating
preconcerting2084415preconcerting
precreasing1645705pre_crea_sing
precutting1546425pre___cutting
predating13514655pre___da_ting
predicating1749655pre_dica_ting
predominating1964345predominating
preempting1745395pre__em_pting
preenacting16125375pre__enacting
preerecting1646145pre_er_ecting
preexempting2661375preexem_pting
prefabbing2042585pref___abbing
prefabricating2461735prefabricating
prefacing17118745pref___a_cing
prefading16149035pref___a_ding
preferring1645625prefer___ring
prefinancing2051945pref_inancing
prefiring1559075prefir____ing
preflighting2252655pref_lighting
prefocusing1953135prefo__cusing
prefocussing2052345prefo_cussing
preformationist2272225preformationist
prefreezing2642875pref_r_eezing
preheating16310725pre__hea_ting
preinforming2072695preinform___ing
prelimiting1645385pre_lim_iting
preloading1446585prelo__a_ding
premarketing2152565premar_keting
premeditating1953655premeditating
prenominating1854695prenominating
preobtaining1752535pre_obtaining
preordain12124495pre_orda__in_
preordains13124525pre_orda__ins
preordering15124305pre_or_dering
prepasting15168885pre___pasting
preplanting1645935pre__planting
preportioning1853605preportioning
preprinting1647415pre_pr_inting
preromantic1755125prero_manti_c
presetting131010835pre___setting
presoaking1736255preso__a_king
pretasting13239285pre___tasting
pretraining1446505pre_tr_aining
prevaricating2153075prevaricating
prewarming18145175prewarm___ing
preworking2044235prewor___king
prewrapping1842395pre_wr_apping
prewriting1647245pre_wr__iting
probating14311195pr__o_ba_ting
procreating1647695pr_ocrea_ting
promoting1439925pr__o_m_oting
prompting1637205pr__o_m_pting
pronating12313765pr__o_na_ting
proofreading1951675proofrea_ding
prorogating1556065pr__orogating
prostrating1449395prostr_a_ting
protonating1448595proto_na_ting
protracting1646935pr__otracting
readmitting1544055_re_admitting
reanimating1447235_reanima_ting
recoating121317465_reco__a_ting
recomputing1844345_reco_mputing
recontacting1745065_recontacting
recrating121318795_re_cr_a_ting
recreating131214585_re_crea_ting
redrafting1545965_re_dr_afting
reemitting1346635_re__emitting
refitting132811125_ref___itting
reflating132514715_ref__la_ting
refloating14198325_ref_loa_ting
reforging1437665_refor___ging
reformat1357655_reforma_t___
reformate1446955_reforma_t__e
reformates1546265_reforma_t_es
reformational18113425_reformational
reformatories1862555_reformatories
reformatory19123445_reforma_tory
reformats1445715_reforma_t__s
refortifying2252795_refortifying
refraining1437265_ref_r_aining
reframing1538625_ref_r_a_ming
refronting1437275_ref_r_onting
regrafting1545995_re_gr_afting
regranting1238325_re_gr_anting
regrating111316215_re_gr_a_ting
regretting1237785_re_gr_etting
relocating13310875_relo_ca_ting
remating112322415_re___ma_ting
remitting122412625_re___mitting
renovating1447425_reno_va_ting
reordaining1343455_re_ordaining
reorienting1246355_re_orienting
reporting12513905_repor___ting
repotting12511125_repo___tting
reprobating1647105_reproba_ting
resonating11311265_reso_na_ting
resorting10614615_resor___ting
resubmitting1752035_resubmitting
retorting10613275_retor___ting
retracting13311935_re_tr_acting
retreating111414775_re_trea_ting
retroacting1447285_re_troacting
retrofitting1653185_retrofitting
trifurcating1852145trifurca_ting

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.390458182.1
2DLD Change Limit1247901708.64314438.3
3Display Results1701700.1061603.8
 (SQL Overall)1786911709.13919552.6
 
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.