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

91 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
bosquet1824922(None) 
bosque17257731bosque_
bosques18217971bosques
bosquets19195251bosquets
bouquet18288261bouquet
banquet1839782banquet
basque17259082basque_
basques18248672basques
bisque17257842bisque_
bisques18236892bisques
bosket124919222bos_ket
bouquets19244522bouquets
briquet1838832briquet
coquet174318012co_quet
mosque17287162mosque_
mosques18256912mosques
roquet154415892ro_quet
toquet154414682to_quet
baguet9316103b_aguet
banquets1935433banquets
barque17239553barque_
barques18259643barques
basinet9318933basinet
basket125722913bas_ket
basset85225383bas_set
bequest1837823b_equest
beset76739133bes__et
besmut10310653besmu_t
biscuit1147373biscuit
bluet75631193b__luet
bomblet13412263bomblet
boneset9316433boneset
bonnet85524633bo_nnet
booklet132312643booklet
boomlet112412273boomlet
boshes114721883bos_hes
bosker123813653bos_ker
boskets13409473bos_kets
boskier13309173boskier
boskiest14289733boskiest
bosomed1238003bosomed
bossed94816533bos_sed
bosses85925403bos_ses
bossier93712423bossier
bossies94116833bossies
bossiest103112213bossiest
bosun75113593bos_u_n
bosuns8439383bos_uns
bout66353293bo__u_t
briquets1934853briquets
brusque1843703brusque_
brusquer1942643brusquer
brusquest2042963brusquest
casque17299273casque_
casqued19235633casqued
casques18278983casques
conquer1838623conquer
conquest1939553conquest
coquets18399893co_quets
coset75748843cos__et
cosset84125863cos_set
croquet1859683croquet
disquiet1879923disquiet
loquat1558283lo_quat
masque17249383masque_
masquer18266463masquer
masques18239363masques
mesquit18387953mesquit
mosquito1942563mosquito
parquet18311583parquet
picquet2047743picquet
piquet17412353_piquet
posset84923253pos_set
racquet1838743racquet
risque15227453risque_
roque144812133ro_que_
roques154912563ro_ques
roquets16398943ro_quets
roset55945243ros__et
squat143720143__squat
squeg1588033__squeg
suet46754823__s_uet
toque145113093to_que_
toques154612353to_ques
toquets16367863to_quets
torque15237673torque_
torqued17224893torqued
torquer16205323torquer
torques16217513torques
usque14137733_usque_
usques15126803_usques

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 Filter1786911340270.420425454.8
2DLD Change Limit134027916.92319359.7
3Display Results91910.0332757.6
 (SQL Overall)178691917.37624226.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.