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

45 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
blanquettes2210203(None) 
banquettes2184371b_anquettes
blanquette2172231blanquette_
banquette2084502b_anquette_
barquettes2174752b_arquettes
languettes1144642_languettes
baguettes12115393b_a_guettes
banqueted2143543b_anque_ted
banqueter2043993b_anque_ter
banqueters2143143b_anqueters
banquets1935433b_anque_t_s
barquette2064903b_arquette_
briquettes2183383b_riquettes
languette1045113_languette_
maquettes2045913_ma_quettes
planchettes1852683planchettes
anisettes946674__anisettes
baguette11105934b_a_guette_
bannerettes1352304bannerettes
banquet1839784b_anque_t__
banqueting2243124b_anqueting
barbettes1348164b_a_rbettes
barrettes1149064b_a_rrettes
blandnesses1446624blandnesses
blanketed1643914blan_ke_ted
blankets14356504blan_ke_t_s
blanknesses1744934blanknesses
briquette2063674b_riquette_
briquetted2262404b_riquetted
brunettes1144584brun__ettes
coquettes2065984__coquettes
croquettes2143544_croquettes
etiquettes1952134_etiquettes
flannelettes1561364flannelettes
languets987244_langue_t_s
laundrettes1251944_laundrettes
layettes1136264_la__yettes
lazarettes1953014_lazarettes
lunettes836754_lun__ettes
maquette1946114_ma_quette_
moquettes2044644__moquettes
netiquettes2051164netiquettes
planchette1753084planchette_
roquettes1855064__roquettes
statuettes1042924sta_tuettes

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 Filter1786911488190.420425454.8
2DLD Change Limit148819458.31317902.0
3Display Results45450.0162812.5
 (SQL Overall)178691458.74920424.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.