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

69 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
sprocket164677(None) 
sprockets1743251sprockets
brocket154013382_brocket
crocket154615672_crocket
pocket144622622_p_ocket
pricket153616442_pricket
rocket125425282__rocket
skyrocket1752672skyrocket
socket123923522s__ocket
bracket154117233_bracket
brockets16328123_brockets
cricket154716953_cricket
crochet143616663_crochet
crocked164014433_crocked
crockets16339543_crockets
docket134721173__docket
frocked17439333_frocked
locket123922473__locket
packet144726503_p_acket
picket144924313_p_icket
placket15412873_placket
pocked154818983_p_ocked
pockets154612253_p_ockets
pricked164613833_pricked
pricker154013413_pricker
prickets16329083_prickets
proceed12310553_proceed
projet15315183_pro_jet
prophet14316033_prophet
propjet1839913_propjet
racket125229423__racket
rochet115423003__rochet
rocked135022323__rocked
rocker124319573__rocker
rockets134615363__rockets
shocked174611813s_hocked
shocker163411433s_hocker
skyrockets1851443skyrockets
smocked16398223s_mocked
socked134721503s__ocked
sockets134012983s__ockets
soroche1237183soroche_
soroches1338803soroches
specked16329013sp_ecked
spirochete1753063spirochete
spoke114818663sp_o_ke_
spoked134413893sp_o_ked
spoken124610003sp_o_ken
spokes124417213sp_o_kes
spooked144510473sp_ooked
sporocyst1643473sporocyst
sprout8419403spro__ut
sprouted1136393sprouted
spruce103910873spruc_e_
spruced12307533spruc_ed
sprucer11317683spruc_er
spruces113810503spruc_es
sprucest12295783sprucest
sprucier1254793sprucier
spruciest1345143spruciest
stocked144312873s_tocked
stocker133713083s_tocker
stricken1436893stricken
stroke105116173stro_ke_
stroked124613623stro_ked
stroker114113523stro_ker
strokes114316323stro_kes
strucken1444323strucken
trocked144312243_trocked

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.423422437.4
2DLD Change Limit146162697.17020385.2
3Display Results69690.0332090.9
 (SQL Overall)178691697.62623431.8
 
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.