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

77 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
paddock1710473(None) 
haddock1885581haddock
paddocks1894321paddocks
padlock1665811padlock
piddock17103651piddock
haddocks1984902haddocks
paddocked2042082paddocked
padlocks1755472padlocks
padouk1336682pa_douk
piddocks1893652piddocks
ruddock1543132ruddock
shaddock1943272shaddock
zaddick2442992zaddick
acock132110213_a_cock
addict10711203_addict
adduce1076453_adduce
adduct1087373_adduct
bannock1545043bannock
bawcock20144033bawcock
bedrock1645643bedrock
burdock1644603burdock
caddice13327733caddice
caprock1736813caprock
cassock1545953cassock
daglock1544263daglock
deadlock1644233deadlock
dock116228743___dock
earlock1336923earlock
hammock2064633hammock
hassock1645443hassock
haycock2144313haycock
headlock1844813headlock
lavrock1644223lavrock
mammock1664393mammock
mattock1535823mattock
mudrock1644353mudrock
oarlock1336123oarlock
pack125535443pa___ck
padauk1335643pa_dauk
padded114113503padd_ed
padder103415493padd_er
padders113312873padders
paddies113715723paddies
padding123412513padding
paddle104615143padd_le
paddled123612023paddled
paddler113711553paddler
paddles113515643paddles
paddocking2142413paddocking
paddy125913593padd__y
paddywack2551133paddywack
padlocked1942433padlocked
padouks1434873pa_douks
padrone102512073padrone
padroni10278613padroni
pandect12310953pandect
pandoor10358583pandoor
pandora1039543pandora
pandore10411853pandore
pandour10408213pandour
pardon94618733pardo_n
pardons103817623pardons
partook1337313partook
payback2056453payback
peacock1745143peacock
petcock1744603petcock
pock126129293p___ock
pollock1546843pollock
prerock1536723prerock
redock134311543_redock
ruddocks1643043ruddocks
shaddocks2043083shaddocks
undock1337703_undock
warlock1636293warlock
wedlock1744553wedlock
yapock17365383ya_pock
zaddik2134243zadd_ik

Search took 7 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.1561145455.1
2DLD Change Limit134027775.90622693.4
3Display Results77770.0302566.7
 (SQL Overall)178691776.09229332.1
 
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.