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

89 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
reformatted175262(None) 
preformatted2052271preformatted
formatted1544882__formatted
reformate1446952reforma_te_
reformates1546262reforma_tes
formatter1445463__formatter
recommitted1853883recommitted
reforested1445383refor_ested
reformable1745293reformable_
reformat1357653reforma_t__
reformation1648413reformation
reformative1945673reformative
reformatory19123443reformatory
reformats1445713reforma_t_s
reformatting1852703reformatting
reformed14249603reform___ed
reformulated1852763reformulated
refracted1557393ref_r_acted
befretted1544374bef_r_etted
decorated13312204decor_a_ted
defatted1335674def___atted
defoliated1545834defolia_ted
deforested1543844defor_ested
deformable1844194deformable_
deformalized2874574deformalized
deformation1747664deformation
deformative2044974deformative
deformed15248264deform___ed
deformities1744284deformities
deratted1048404de__r_atted
formate123115094__forma_te_
formates132814294__forma_tes
formatters1544574__formatters
intermatted1476304intermatted
perforated1656894perfor_a_ted
permitted1446654pe__rmitted
perorated12412464peror_a_ted
preformat1646364preforma_t__
preformation1946474preformation
preformats1744414preforma_t_s
preformatting2152074preformatting
preformed17176204preform___ed
preformulated2162034preformulated
pretermitted1752264pretermitted
readmitted1443464re_admitted
reanimated1347004reanima_ted
recoated113416784reco__a_ted
recomputed1744724reco_mputed
recontacted1654714recontacted
recrated112918604re_cr_a_ted
recreated12412534re_crea_ted
redrafted1435144re_dr_afted
reemitted1245944re__emitted
refitted12309414ref___itted
reflated123514294ref__la_ted
refloated1347014ref_loa_ted
reforged13268704refor___ged
reformations1747604reformations
reformatories1862554reformatories
reformer13217954reform___er
reformist1445914reformist__
reformists1544124reformist_s
reformulate1653024reformulate_
reformulates1752984reformulates
refortified1853444refortified
refrained1347224ref_r_ained
reframed1437854ref_r_a_med
refronted1336054ref_r_onted
regrafted1435244re_gr_afted
regranted1137704re_gr_anted
regrated102816334re_gr_a_ted
regretted1137234re_gr_etted
relocated12710814relo_ca_ted
remated103522474re___ma_ted
remitted113312074re___mitted
renovated1347174reno_va_ted
reordained1243444re_ordained
reoriented1145344re_oriented
reported11312704repor___ted
repotted1139284repo___tted
reprobated1546384reproba_ted
resonated10510614reso_na_ted
resorted9313494resor___ted
resubmitted1652014resubmitted
retorted9312334retor___ted
retracted12410954re_tr_acted
retreated10312624re_trea_ted
retroacted1366134re_troacted
retrofitted1552604retrofitted

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 Filter1786911488190.453394461.4
2DLD Change Limit148819899.36015899.5
3Display Results89890.0461934.8
 (SQL Overall)178691899.85918124.7
 
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.