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

75 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
bouquets1924452(None) 
bosquets19195251bosquets
bouquet18288261bouquet_
banquets1935432banquets
bosques18217972bosque_s
bosquet18249222bosquet_
briquets1934852briquets
coquets18399892co_quets
roquets16398942ro_quets
toquets16367862to_quets
baguets1037483b_aguets
banquet1839783banquet_
barques18259643barque_s
basques18248673basque_s
bequest1837823b_equest
bequests1944113b_equests
bisques18236893bisque_s
bluets87215493b__luets
bomblets1436023bomblets
bonesets1036843bonesets
bonnets94812803bo_nnets
booklets14247123booklets
boomlets12246673boomlets
boskets13409473bo_skets
bosque17257733bosque__
bouchees15339533bouchees
boucles113113003boucle_s
bouffes15388633bouffe_s
bougies103715183bougie_s
boulders113010033boulders
boules84925973bou_le_s
boulles93114123boulle_s
bouncers12309353bouncers
bounces113813683bounce_s
bounders114314113bounders
bournes93615023bourne_s
bourrees10127643bourrees
bourses94014303bourse_s
bouses84931783bou_se_s
boutiques2043193boutique_s
bouts75131313bo__u_ts
bouviers1375003bouviers
briquet1838833briquet_
brunets9419553bru_nets
brusquest2042963brusquest
buckets153811693b_uckets
budgets11489863b_udgets
buffets15317593b_uffets
bullets93516393b_ullets
burets84321263b_u_rets
burnets93813263b_urnets
bututs8409423b_utu_ts
conquers1938223conquers
conquest1939553conquest
conquests2045363conquests
coquet174318013co_quet_
couplets12389873couplets
croquets1955213croquets
doublets11257363doublets
gourmets1144153gourmets
loquats1645273lo_quats
mosques18256923mosque_s
outlets73616363_outlets
outsets73514923_outsets
parquets1936413parquets
picquets2143733picquets
piquets1836603_piquets
racquets1944763racquets
roques154912563ro_que_s
roquet154415893ro_quet_
toques154612353to_que_s
toquet154414683to_quet_
torquers17204303torquers
torques16217513torque_s
tuques15358373_tuque_s

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 Limit146162757.47019566.5
3Display Results75750.0302500.0
 (SQL Overall)178691757.92022562.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.