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

91 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
mullocks164503(None) 
bullocks1636291bullocks
mullock1535711mullock_
mullocky1942811mullocky
bollocks1636502bollocks
bullock1537192bullock_
bullocky1943642bullocky
gunlocks1544682gunlocks
hillocks1736062hillocks
killocks1354792killocks
mudrocks1743992mudrocks
pollocks1656472pollocks
unlocks1337062_unlocks
armlocks1643963armlocks
blocks144513943__blocks
bullaces12299433bullaces
bullnecks1742273bullnecks
bullous9311663bullo_us
burdocks1744033burdocks
buttocks1645233buttocks
clocks144916233__clocks
daglocks1643993daglocks
earlocks1435693earlocks
elflocks1742743elflocks
fetlocks1744713fetlocks
flocks154713533__flocks
fullbacks2043603fullbacks
futtocks1743833futtocks
gunlock1444563gunlock_
hemlocks1944993hemlocks
hillock1646693hillock_
hillocky2053403hillocky
hulloas103911913hullo_as
hulloes104113923hullo_es
hulloos104010073hullo_os
hullos94916293hullo__s
hummocks2163453hummocks
killicks1354873killicks
killock1255253killock_
locks115126923___locks
mallows123714323mallo_ws
mammocks1763893mammocks
mattocks1644983mattocks
mellows123812233mello_ws
millworks1845093millworks
mocks135023823m___ocks
mollusks14102653mollusks
molochs1435223m_olochs
mucklucks18151883mucklucks
mucks134622643mu___cks
muclucs1343683mucluc_s
mudlarks1542883mudlarks
mudpacks1943233mudpacks
mudrock1644353mudrock_
mukluks1242413mukl_uks
mulcts10298713mu_l_cts
mullahs12388733mull_ahs
mullas84215933mull__as
mulleins10277053mulleins
mullens93611313mull_ens
mullers93217303mull_ers
mullets93614783mull_ets
mulleys12299203mull_eys
mullions101910353mullions
mullites10411643mullites
mulls75124153mull___s
musicks15297053mu_sicks
oarlocks1445103oarlocks
outlooks1236793outlooks
outrocks1437903outrocks
padlocks1755473padlocks
pollacks1656373pollacks
pollock1546843pollock_
pullbacks1943773pullbacks
pullouts1045223pullouts
relocks134411293_relocks
rollicks1444893rollicks
rowlocks1744353rowlocks
ruddocks1643043ruddocks
schlocks19245693schlocks
shlocks16317183_shlocks
shylocks2044153shylocks
subblocks1943003subblocks
sunblocks1743413sunblocks
tussocks1443333tussocks
unblocks1644523unblocks
uncocks1537233_uncocks
undocks1436163_undocks
unlock1248533_unlock_
warlocks1735363warlocks
wedlocks1844393wedlocks

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.406440125.6
2DLD Change Limit146162916.81321453.4
3Display Results91910.0332757.6
 (SQL Overall)178691917.25224640.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.