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

80 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
mattocks164498(None) 
mattock1535821mattock_
attacks13126942_attacks
bittocks1644442bittocks
buttocks1645232buttocks
fatstocks1843452fatstocks
futtocks1743832futtocks
mammocks1763892mammocks
mattoids1196182mattoids
amtracks1696633amtracks
anticks134612253_anticks
attack12148153_attack_
attics84413283_attic_s
attorns738443_attorns
bannocks1644353bannocks
battiks1337143batt_iks
bawcocks21113443bawcocks
bitstocks1743293bitstocks
bittock1544433bittock_
buttock1545563buttock_
caprocks1835943caprocks
cassocks1645033cassocks
daglocks1643993daglocks
dattos74311903datto__s
earlocks1435693earlocks
fatbacks1946003fatbacks
fatstock1743613fatstock_
fetlocks1744713fetlocks
futtock1644153futtock_
haddocks1984903haddocks
hammocks2164343hammocks
hassocks1744693hassocks
hatracks1737533hatracks
haycocks2244113haycocks
lattices1038383lattices
lavrocks1743663lavrocks
macks135127603ma___cks
madtoms1236923madto_ms
mafficks2243173mafficks
maltols939403malto_ls
maltoses1039853maltoses
mammock1664393mammock_
maniocas12298473maniocas
maniocs113611443manioc_s
mastics112614783mastic_s
mastoids1177873mastoids
matchlocks2352303matchlocks
matrices12312083matrices
matrons93517633matro_ns
matters94421753matt_ers
mattes85624533matt__es
mattings11369673mattings
mattins93316143matt_ins
mattoid1079283matto_id
mattrass1045863mattrass
mattress1036533mattress
matts76829183matt___s
matzohs2134373matzo_hs
matzoons19105083matzoons
matzos1749263matzo__s
mocks135023823m___ocks
mottoes93412193motto_es
mottos84615243motto__s
mudrocks1743993mudrocks
mullocks1645033mullocks
muttons949283mutto_ns
oarlocks1445103oarlocks
outrocks1437903outrocks
paddocks1894323paddocks
padlocks1755473padlocks
petcocks1844583petcocks
rattons73815323ratto_ns
rattoons8327513rattoons
reattacks1543753reattacks
restocks1437503restocks
stocks124715633__stocks
tattoos738643tatto_os
trocks123614633__trocks
warlocks1735363warlocks
yapocks18354723ya_pocks

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.420425454.8
2DLD Change Limit146162806.75021653.6
3Display Results80800.0332424.2
 (SQL Overall)178691807.20324807.9
 
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.