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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
bouquet1828826(None) 
bosquet18249221bosquet
bouquets19244521bouquets
banquet1839782banquet
bosque17257732bosque_
bosques18217972bosques
bosquets19195252bosquets
briquet1838832briquet
coquet174318012co_quet
roquet154415892ro_quet
toquet154414682to_quet
baguet9316103b_aguet
banquets1935433banquets
barque17239553barque_
barques18259643barques
basque17259083basque_
basques18248673basques
bequest1837823b_equest
bisque17257843bisque_
bisques18236893bisques
bluet75631193b__luet
bomblet13412263bomblet
boneset9316433boneset
bonnet85524633bo_nnet
booklet132312643booklet
boomlet112412273boomlet
bosket124919223bo_sket
bouchee143313543bouchee
boucle103712783boucle_
boucles113113003boucles
bouffe14438313bouffe_
bouffes15388633bouffes
boughed143810263boughed
bought125115633bou_ght
bougie93613273bougie_
bougies103715183bougies
boulder103411343boulder
boule74828043bou_le_
boules84925973bou_les
boulle84614613boulle_
boulles93114123boulles
bounce104014833bounce_
bounced123610553bounced
bouncer113811333bouncer
bounces113813683bounces
bounded113613763bounded
bounden10389453bounden
bounder104215533bounder
bourne83714093bourne_
bournes93615023bournes
bourree91311343bourree
bourse84414333bourse_
bourses94014303bourses
bouse75931853bou_se_
boused95322883bou_sed
bouses84931783bou_ses
bout66353293bo__u_t
boutique1943283boutique_
boutiques2043193boutiques
boutiquey2351933boutiquey
bouvier1277433bouvier
briquets1934853briquets
brunet84419293bru_net
brusque1843703brusque_
brusquer1942643brusquer
brusquest2042963brusquest
bucket144620733b_ucket
budget104618123b_udget
buffet143113783b_uffet
bullet84528613b_ullet
buret77444013b_u_ret
burnet84326173b_urnet
butut75522913b_utu_t
conquer1838623conquer
conquest1939553conquest
coquets18399893co_quets
couplet114717943couplet
croquet1859683croquet
doublet103914033doublet
gourmet1059203gourmet
loquat1558283lo_quat
mosque17287163mosque_
mosques18256913mosques
outlet63728683_outlet
outset64027453_outset
parquet18311583parquet
picquet2047743picquet
piquet17412353_piquet
racquet1838743racquet
roque144812133ro_que_
roques154912563ro_ques
roquets16398943ro_quets
roupet84218343rou_pet
toque145113093to_que_
toques154612353to_ques
toquets16367863to_quets
torque15237673torque_
torqued17224893torqued
torquer16205323torquer
torques16217513torques
tuque14469193_tuque_
tuques15358373_tuques

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 Filter1786911340270.410435831.7
2DLD Change Limit1340271026.20021617.3
3Display Results1021020.0333090.9
 (SQL Overall)1786911026.64326899.1
 
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.