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

117 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
banquets193543(None) 
banquet1839781banquet_
baguets1037482ba_guets
bannets94013842ban_nets
banqueted2143542banqueted
banqueter2043992banqueter
banqueters2143142banqueters
banquette2084502banquette
banquettes2184372banquettes
barques18259642barque_s
basques18248672basque_s
bosquets19195252bosquets
bouquets19244522bouquets
briquets1934852briquets
languets987242languets
parquets1936412parquets
racquets1944762racquets
acquest1837173_acquest
acquests1944643_acquests
acquits1857293_acquits
anklets114310413_anklets
annulets845813_annulets
backsets1638853backsets
baguet9316103ba_guet_
ballets93719513ba_llets
ballutes1037523ballutes
banders104324563ban_ders
bandies104124863bandie_s
bandits103814793ban_dits
banes74945583ban__e_s
bangers104020353ban_gers
bangles103617413bangle_s
banjoes16317313banjoe_s
bankers133919093ban_kers
bankits133410153ban_kits
bankrupts1741893bankrupts
bannerets11205463bannerets
banners94018713ban_ners
bannet84925333ban_net_
banqueting2243123banqueting
banshees13127863banshees
banters94623113ban_ters
banties94324763bantie_s
barbets114915843ba_rbets
barbuts11439843barbu_ts
barguest1137163barguest
barguests1243483barguests
baronets101410903baronets
baroques1934863baroque_s
barque17239553barque__
barquette2064903barquette
barquettes2174753barquettes
barrets94917103ba_rrets
basinets1039063basinets
baskets135111833ba_skets
basque17259083basque__
bassets96414823ba_ssets
battues94610193battue_s
bayonets13135583bayonets
bennets94712163ben_nets
bequest1837823b_equest
bequests1944113b_equests
bisques18236893bisque_s
blankets14356503blan_kets
blanquette2172233blanquette
blanquettes22102033blanquettes
bluets87215493b__luets
bonesets1036843bonesets
bonnets94812803bon_nets
bosques18217973bosque_s
bosquet18249223bosquet_
bouquet18288263bouquet_
briquet1838833briquet_
caiques18248793caique_s
calques182710193calque_s
cangues10611823cangue_s
casques18278983casque_s
cinques1837333cinque_s
conquers1938213conquers
conquest1939553conquest
conquests2045363conquests
coquets18399893_coquets
croquets1955213croquets
fanjets1734803fan_jets
gangues9149753gangue_s
gannets83811443gan_nets
gantlets9308903gantlets
handsets12258343handsets
inquest1638603_inquest
inquests1744943_inquests
inquiets1745433_inquiets
lacquers19125033lacquers
lacqueys22132693lacqueys
lancets93411163lan_cets
langues81211913langue_s
languet8713693languet_
manchets15269573manchets
manhunts1344043manhunts
manque17259513manque__
mantlets104611203mantlets
marquees19206243marquees
marques182610863marque_s
marquess19204953marquess
masquers19195703masquers
masques18239363masque_s
minuets9259853min_uets
paraquets2044593paraquets
paroquets2043643paroquets
parquet18311583parquet_
picquets2143733picquets
piquets1836603_piquets
racquet1838743racquet_
roquets16398943_roquets
sacques18106863sacque_s
toquets16367863_toquets
unquiets1744313_unquiets
yanquis1943723yanqu_is

Search took 10 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.1561145455.1
2DLD Change Limit1461621179.21615859.6
3Display Results1171170.0462543.5
 (SQL Overall)1786911179.41818973.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.