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

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

80 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
reformatting185270(None) 
preformatting2152071preformatting
formatting1644162__formatting
recommitting1954133recommitting
reforesting1546193refor_esting
reformation1648413reforma_tion
reformations1747603reformations
reformative1945673reforma_tive
reformatted1752623reformatt_ed
reforming1538563reform___ing
reformulating1972823reformulating
refracting1638733ref_r_acting
befretting1644794bef_r_etting
decorating14312074decor_a_ting
defatting1436104def___atting
defoliating1645824defolia_ting
deforesting1654794defor_esting
deformalizing2954224deformalizing
deformation1747664deforma_tion
deformations1846844deformations
deformative2044974deforma_tive
deforming1636704deform___ing
deratting1139514de__r_atting
forgetting1544664__forgetting
formfitting2051894__formfitting
intermatting1547174intermatting
perforating1747024perfor_a_ting
permitting1546304pe__rmitting
perorating13313134peror_a_ting
preformation1946474preforma_tion
preformations2045714preformations
preformatted2052274preformatt_ed
preforming1846234preform___ing
preformulating2281874preformulating
pretermitting1852554pretermitting
readmitting1544054re_admitting
reanimating1447234reanima_ting
recoating121317464reco__a_ting
recomputing1844344reco_mputing
recontacting1745064recontacting
recrating121318794re_cr_a_ting
recreating131214584re_crea_ting
redrafting1545964re_dr_afting
reemitting1346634re__emitting
refitting132811124ref___itting
reflating132514714ref__la_ting
refloating14198324ref_loa_ting
reforging1437664refor___ging
reformat1357654reforma_t___
reformate1446954reforma_t__e
reformates1546264reforma_t_es
reformational18113424reformational
reformatories1862554reformatories
reformatory19123444reforma_tory
reformats1445714reforma_t__s
refortifying2252794refortifying
refraining1437264ref_r_aining
reframing1538624ref_r_a_ming
refronting1437274ref_r_onting
regrafting1545994re_gr_afting
regranting1238324re_gr_anting
regrating111316214re_gr_a_ting
regretting1237784re_gr_etting
relocating13310874relo_ca_ting
remating112322424re___ma_ting
remitting122412624re___mitting
renovating1447424reno_va_ting
reordaining1343454re_ordaining
reorienting1246354re_orienting
reporting12513904repor___ting
repotting12511124repo___tting
reprobating1647104reproba_ting
resonating11311264reso_na_ting
resorting10614614resor___ting
resubmitting1752034resubmitting
retorting10613274retor___ting
retracting13311934re_tr_acting
retreating111414774re_trea_ting
retroacting1447284re_troacting
retrofitting1653184retrofitting

Search took 9 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.406440125.6
2DLD Change Limit124790808.42314815.4
3Display Results80800.0461739.1
 (SQL Overall)178691808.87520134.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.