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

103 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
racquet183874(None) 
racquets1944761racquets
acquest1837172_acquest
acquit17610322_acquit
banquet1839782banquet
lacquer18135152lacquer
lacquey21143802lacquey
parquet18311582parquet
picquet2047742picquet
rachet115028972rac_het
racket125229422rac_ket
roquet154415892r_oquet
sacque17107112sacque_
sacques18106862sacques
acquests1944643_acquests
acquits1857293_acquits
acute74720363_ac_ute
backset15314193backset
baguet9316103ba_guet
banquets1935433banquets
barque17239553barque_
barques18259643barques
basque17259083basque_
basques18248673basques
bosquet18249223bosquet
bouquet18288263bouquet
bracelet12310693bracelet
brachet144020313brac_het
bracket154117233brac_ket
bractlet1239283bractlet
briquet1838833briquet
cachet134526413cac_het
cacique20205693cacique_
caciques21165373caciques
caique17318803caique_
caiques18248793caiques
calque17289843calque_
calqued19306523calqued
calques182710193calques
casque17299273casque_
casqued19235633casqued
casques18278983casques
coquet174318013_coquet
croquet1859683croquet
cruet74831843__cruet
facet106038523fac__et
jacket194720673jac_ket
jaconet16311483jaconet
lacquers19125033lacquers
lacqueys22132693lacqueys
languet8713693languet
macaque2044053macaque_
macaques2143953macaques
manque17259513manque_
marque172410503marque_
marquee18218583marquee
marques182610863marques
masque17249383masque_
masquer18266463masquer
masques18239363masques
packet144726503pac_ket
paraquet1948783paraquet
paroquet1947283paroquet
parquets1936413parquets
picquets2143733picquets
piquet17412353_piquet
rabbet103818653ra_bbet
race66746263rac__e_
raced87635313rac__ed
raceme1039733raceme_
racemed1237013racemed
racemes1139093racemes
racer75233023rac__er
races74943243rac__es
rachets124516833rac_hets
racier85120973rac_ier
raciest92820013raciest
racist82822793rac_ist
racked134526083rac_ked
racker124824553rac_ker
rackets134916873rac_kets
rackety16499113rac_kety
rackle123917293rackle_
ragout7317183ragou_t
ramet75743143ra__met
ramjet15311543ra_mjet
ratchet124218333ratchet
recount9315173recount
recruit939773recruit
recut74729243rec_u_t
relacquer2042193relacquer
request16311023r_equest
risque15227453risque_
rochet115423003roc_het
rocket125425283roc_ket
roque144812133r_oque_
roques154912563r_oques
roquets16398943r_oquets
sacbut10811943sacbu_t
sachet114725773sac_het
tacet75840023tac__et
tacket124627493tac_ket
toquet154414683_toquet

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271037.59617644.4
3Display Results1031030.0303433.3
 (SQL Overall)1786911038.02922255.7
 
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.