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

106 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
mattock153582(None) 
mattocks1644981mattocks
attack12148152_attack
bittock1544432bittock
buttock1545562buttock
fatstock1743612fatstock
futtock1644152futtock
mammock1664392mammock
mattoid1079282mattoid
acock132110213_a_cock
amtrack15107393amtrack
antick124814583_antick
attach11118393_attach
attacks13126943_attacks
attic75618353_attic_
attics84413283_attics
attorn6310793_attorn
bannock1545043bannock
battik1238093batt_ik
bawcock20144033bawcock
bitstock1643333bitstock
bittocks1644443bittocks
buttocks1645233buttocks
caprock1736813caprock
cassock1545953cassock
daglock1544263daglock
datto65416423datto__
dattos74311903datto_s
earlock1336923earlock
fatback1836923fatback
fatstocks1843453fatstocks
fetlock1645323fetlock
futtocks1743833futtocks
haddock1885583haddock
hammock2064633hammock
hassock1645443hassock
hatrack1638213hatrack
haycock2144313haycock
lattice938433lattice
lavrock1644223lavrock
mack125733653ma___ck
madtom1138023madto_m
madtoms1236923madtoms
maffick2143523maffick
maltol8310843malto_l
maltols939403maltols
maltose939783maltose
mammocks1763893mammocks
manioc103914823manioc_
manioca11358943manioca
maniocs113611443maniocs
manpack1746063manpack
mantic104120903mantic_
mastic103119173mastic_
mastics112614783mastics
mastoid10711233mastoid
match125621103ma_t_ch
matchlock2252403matchlock
matron83918313matro_n
matrons93517633matrons
matt65752663matt___
matte75626843matt__e
matted94521413matt_ed
matter84325343matt_er
matters94421753matters
mattery123810713mattery
mattes85624533matt_es
mattin84416633matt_in
matting103620143matting
mattins93316143mattins
mattoids1196183mattoids
matts76829183matt__s
matzo16312893matzo__
matzoh2035483matzo_h
matzohs2134373matzohs
matzoon1896473matzoon
matzos1749263matzo_s
matzot17710983matzo_t
matzoth2144333matzoth
mistook1337153mistook
mock126429443m___ock
motto76119513motto__
mottoes93412193mottoes
mottos84615243motto_s
mudrock1644353mudrock
mullock1535713mullock
mutton8510453mutto_n
muttons949283muttons
muttony1235323muttony
oarlock1336123oarlock
outrock1339303outrock
paddock17104733paddock
padlock1665813padlock
partook1337313partook
petcock1744603petcock
ratton64116123ratto_n
rattons73815323rattons
rattoon7359243rattoon
reattack1444123reattack
restock1338673restock
stock114417563__stock
tattoo6310973tatto_o
tattoos738643tattoos
trock114817603__trock
warlock1636293warlock
yapock17365383ya_pock

Search took 10 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.470380193.6
2DLD Change Limit1340271068.78315259.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.29919216.2
 
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.