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 “hillocks” 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
hillocks173605(None) 
hillock1646691hillock_
hillocky2053401hillocky
killocks1354781killocks
bollocks1636502bollocks
bullocks1636292bullocks
hairlocks1863772hairlocks
hemlocks1944992hemlocks
hilloas104413542hillo_as
hillocked1942792hillocked
hilloes103815942hillo_es
hillos94618882hillo__s
killicks1354872killicks
killock1255252killock_
mullocks1645032mullocks
pollocks1656472pollocks
armlocks1643963armlocks
bibcocks2043573bibcocks
billhooks1843223billhooks
billons93013353billo_ns
billows123611283billo_ws
billycocks2351453billycocks
bittocks1644443bittocks
blocks144513943__blocks
bullock1537193bullock_
bullocky1943643bullocky
charlocks2044073charlocks
clocks144916233__clocks
daglocks1643993daglocks
earlocks1435693earlocks
elflocks1742743elflocks
fetlocks1744713fetlocks
fillos94415073fillo__s
firelocks1844233firelocks
flocks154713533__flocks
gridlocks1742683gridlocks
gunlocks1544683gunlocks
haddocks1984903haddocks
hairlock1754023hairlock_
halloas104318463hallo_as
halloes104021513hallo_es
halloos103716743hallo_os
hallos95425103hallo__s
hallows134417393hallo_ws
halluces1335613halluces
hammocks2164343hammocks
hassocks1744693hassocks
havelocks2143263havelocks
haycocks2244113haycocks
headlocks1944463headlocks
helloes103717453hello_es
hellos95321683hello__s
hemlock1845633hemlock_
hicks145322173hi___cks
hijacks2333533hi_jacks
hillers103718723hill_ers
hillo84721653hillo___
hilloa94713033hillo__a
hilloaed12136923hilloaed
hilloed113211293hillo_ed
hilloing12158293hilloing
hills85431353hill___s
hilltops1344913hilltops
hocks144925493h___ocks
holloas103814943hollo_as
holloes103818193hollo_es
holloos104013583hollo_os
hollos95320633hollo__s
hollows134412333hollo_ws
hollyhocks2551423hollyhocks
hommocks2143993hommocks
hulloas103911913hullo_as
hulloes104113923hullo_es
hulloos104010073hullo_os
hullos94916293hullo__s
hummocks2163453hummocks
killick1295313killick_
locks115126923___locks
millworks1845083millworks
mullock1535713mullock_
mullocky1942813mullocky
niblicks1643763niblicks
oarlocks1445103oarlocks
padlocks1755473padlocks
picklocks1843433picklocks
piddocks1893653piddocks
pillows122610103pillo_ws
pollacks1656373pollacks
pollock1546843pollock_
relocks134411293_relocks
rimrocks1644043rimrocks
rollicks1444893rollicks
rowlocks1744353rowlocks
schlocks19245693schlocks
shellacks1844553shellacks
sherlocks1843953sherlocks
shlocks16317173_shlocks
shylocks2044153shylocks
unblocks1644523unblocks
unlocks1337063_unlocks
villous102810013villo_us
warlocks1735363warlocks
wedlocks1844393wedlocks
willows13299743willo_ws
winnocks1743873winnocks
ziplock2454413ziplock_

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 Filter1786911461620.186960704.3
2DLD Change Limit1461621068.83016552.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.06219718.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.