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

50 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
formatting164416(None) 
forgetting1544662forgetting
formfitting2051892formfitting
reformatting1852702reformatting
borating113414503bor_a_ting
bromating1439183broma_ting
combatting1755143combatting
committing1746683committing
corotating1349323corotating
deratting1139513der_atting
dratting10389663_dr_atting
fatting113818703f___atting
fermenting1646823fermenting
flatting123511253f__latting
foliating1339253folia_ting
fomenting1537233fo_menting
foraging1358063for_a_ging
foraying1537433for_a_ying
forearming1644193forearming
forecasting1744473forecasting
foredating1577123foredating
foresting13311363for_esting
foretasting1554423foretasting
forfeiting1744133forfeiting
formalin1347313forma_lin_
formalins1447213forma_lins
formalising1754863formalising
formalizing2646643formalizing
formation1439423forma_tion
formations1538203formations
formative1747963forma_tive
formatted1544883formatt_ed
formatter1445463formatt_er
formatters1544573formatters
forming133615733form___ing
formulating1765053formulating
forsaking1745173forsa_king
forwarding1843493forwarding
fretting122711523f_r_etting
fritting123510703f_r_itting
furcating1537783furca_ting
matting103620143___matting
mordanting1444003mordanting
omitting11217743_o_mitting
orating83520323_or_a_ting
permitting1546303permitting
preformatting2152073preformatting
ratting83822363__r_atting
tomcatting1542433tomcatting
tormenting1345693tormenting

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 Filter1786911406030.406440125.6
2DLD Change Limit140603506.23322557.8
3Display Results50500.0163125.0
 (SQL Overall)178691506.65526850.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.