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

58 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
furmenty164529(None) 
frumenty1644571frumenty
furmety1534811furme_ty
ferment12315572ferment_
ferments13311472ferments
fromenty1645242fromenty
furmity1535182furm_ity
augment10910203augment_
augments1137833augments
currency1545543currency
current9313693current_
currently1445093currently
currents1038373currents
fermented1546623fermented
fermenter1497543fermenter
fermentor1444693fermentor
ferrety13287013ferre_ty
fervency1944383fervency
fervent13310063fervent_
fervently1845143fervently
figment1379743figment_
figments1446943figments
firmest1239273firmest_
fitment12710303fitment_
fitments1376793fitments
foment113718303f_oment_
foments122912053f_oments
formant123416003formant_
formants13269953formants
formerly1645003formerly
fornent10312933fornent_
forwent13310533forwent_
fourpenny1761433fourpenny
frenzy2135883f_r_enzy
fretty1249223f_r_etty
fulgent1138903fulgent_
fulgently1643543fulgently
fumet105630223fu_me_t_
fumets114311813fu_me_ts
fumette1245523fu_mette
furmenties1544853furmenties
garment10315233garment_
garments1139963garments
hutment1239173hutment_
hutments1345603hutments
sarment9318763sarment_
sarmenta1047723sarmenta
sarments10311963sarments
surety93515013sur_e_ty
torment9316173torment_
torments10310453torments
turgency1444833turgency
turgent8712393turgent_
urgency1345663_urgency
urgent73816043_urgent_
urgently1245623_urgently
varment12313243varment_
varments1339063varments

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.420425454.8
2DLD Change Limit146162586.72021750.3
3Display Results58580.0301933.3
 (SQL Overall)178691587.17024922.0
 
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.