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

71 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
burdocks174403(None) 
burdock1644601burdock_
bedrocks1745332bedrocks
brocks145214152b_r_ocks
bullocks1636292bullocks
buttocks1645232buttocks
mudrocks1743992mudrocks
ruddocks1643042ruddocks
undocks1436162_undocks
aurochs1245983aur_ochs
bannocks1644353bannocks
barracks1636883barracks
bawcocks21113443bawcocks
bedecks1635793b_edecks
bedrock1645643bedrock_
bemocks1735373b_emocks
bibcocks2043573bibcocks
bittocks1644443bittocks
blocks144513943b__locks
bocks134526573b___ocks
bollocks1636503bollocks
bonnocks1644623bonnocks
boondocks1863023boondocks
bourdons1136433bourdo_ns
bricks144614623b_r_icks
brock136017073b_r_ock_
brooks125813883b_r_ooks
bucks134824293bu___cks
bullock1537193bullock_
bullocky1943643bullocky
burbots1168673burbo_ts
burdens1039713burd_ens
burdies104117563burd_ies
burds84626063burd___s
burgoos1037123burgo_os
burgouts1145123burgouts
burlesks1443223burlesks
burnous938823burno_us
burnouts1045263burnouts
burros85114993burro__s
burrows12399093burro_ws
burtons9310853burto_ns
buttock1545563buttock_
buybacks2144783buybacks
crocks145118423_cr_ocks
docks126022313___docks
dornocks1544093dornocks
durocs9569703dur_oc_s
earlocks1435693earlocks
frocks154111213_fr_ocks
futtocks1743833futtocks
gorcocks1743423gorcocks
gunlocks1544683gunlocks
haddocks1984903haddocks
hummocks2163453hummocks
mudrock1644353mudrock_
mullocks1645033mullocks
oarlocks1445103oarlocks
outrocks1437903outrocks
paddocks1894323paddocks
piddocks1893653piddocks
redocks14409933_redocks
rocks114626413__r_ocks
ruddock1543133ruddock_
sundecks1544253sundecks
trocks123614633_tr_ocks
tussocks1443333tussocks
uncocks1537233_uncocks
undock1337703_undock_
unlocks1337063_unlocks
warlocks1735363warlocks

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 Limit146162716.61022112.3
3Display Results71710.0302366.7
 (SQL Overall)178691717.06325299.6
 
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.