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

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
reformat135765(None) 
preformat1646361preformat
reformate1446951reformate
reformats1445711reformats
format113021352__format
preformats1744412preformats
reforest1139962reforest
reform11312712reform__
reformates1546262reformates
reformed14249602reformed
reformer13217952reformer
reformist1445912reformist
reforms1239822reform_s
deforest1238793deforest
deform1259623deform__
deformed15248263deformed
deformer14247943deformer
deformity1843033deformity
deforms1337803deform_s
doormat1059073_doormat
forgat104018583__forgat
formal113215203__formal
formant123416003__formant
formate123115093__formate
formats123113573__formats
informal1355643informal
informant1446473informant
preform1439613preform__
preformed17176203preformed
preforms1537403preform_s
proforma1545433proforma_
recoat84024273reco__at
recommit1445553recommit
referent112813423referent
referral1144403referral
refloat10310833ref_loat
reforests1245533reforests
reforge11259033refor_ge
reforged13268703reforged
reforges12249333reforges
reformable1745293reformable
reformation1648413reformation
reformative1945673reformative
reformatory19123443reformatory
reformatted1752623reformatted
reformers14246403reformers
reforming1538563reforming
reformism1643703reformism
reformists1544123reformists
reformulate1653023reformulate
refought1564233refought
refract121311603ref_ract
reframe1239393ref_rame
refront10313263ref_ront
remora8414593remor_a_
remoras9314073remor_as
report85326023repor__t
resort65728623resor__t
retort66831153retor__t
retreat7317533re_treat

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit146162606.53322372.9
3Display Results60600.0302000.0
 (SQL Overall)178691606.99925530.9
 
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.