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

110 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
mullock153571(None) 
bullock1537191bullock
mullocks1645031mullocks
mullocky1942811mullocky
bullocks1636292bullocks
bullocky1943642bullocky
gunlock1444562gunlock
hillock1646692hillock
killock1255252killock
mudrock1644352mudrock
pollock1546842pollock
unlock1248532_unlock
armlock1544313armlock
block134917843__block
bollocks1636503bollocks
bullace113410673bullace
bullneck1642933bullneck
bullous9311663bullous
burdock1644603burdock
buttock1545563buttock
clock134917983__clock
daglock1544263daglock
earlock1336923earlock
elflock1642973elflock
fetlock1645323fetlock
flock144717423__flock
fullback1943853fullback
futtock1644153futtock
gunlocks1544683gunlocks
hemlock1845633hemlock
hillocks1736063hillocks
hillocky2053403hillocky
hullo84417453hullo__
hulloa95011183hullo_a
hulloas103911913hulloas
hulloed11369793hulloed
hulloes104113923hulloes
hulloo94511733hullo_o
hulloos104010073hulloos
hullos94916293hullo_s
hummock2063793hummock
killick1295313killick
killocks1354793killocks
lock106134363___lock
mallow114014743mallo_w
mallows123714323mallows
mammock1664393mammock
mattock1535823mattock
mellow114112223mello_w
mellows123812233mellows
millwork1745523millwork
mock126429443m___ock
mollusk13103123mollusk
moloch1356483m_oloch
muck125727853mu___ck
muckluck17121923muckluck
mucluc1245053mucluc_
muclucs1343683muclucs
mudlark1463913mudlark
mudpack1843593mudpack
mudrocks1743993mudrocks
mukluk1143503mukl_uk
mulch124012973mu_l_ch
mulct93820083mu_l_ct
mull65128803mull___
mulla74317113mull__a
mullah113710733mull_ah
mullahs12388733mullahs
mullas84215933mull_as
mulled94721553mull_ed
mullein9278563mullein
mullen83714763mull_en
mullens93611313mullens
muller83820353mull_er
mullers93217303mullers
mullet84126823mull_et
mullets93614783mullets
mulley114013453mull_ey
mulleys12299203mulleys
mulling103819993mulling
mullion91911173mullion
mullions101910353mullions
mullite9313013mullite
mulls75124153mull__s
musick14408703mu_sick
oarlock1336123oarlock
outlook1138023outlook
outrock1339303outrock
padlock1665813padlock
pollack1567333pollack
pollocks1656473pollocks
pullback1844243pullback
pullout9310593pullout
relock124713523_relock
rollick1335613rollick
rowlock1654783rowlock
ruddock1543133ruddock
schlock18235873schlock
shlock15378193_shlock
shylock1945053shylock
subblock1843673subblock
sunblock1643763sunblock
tussock1343833tussock
unblock1545793unblock
uncock1438563_uncock
undock1337703_undock
unlocks1337063_unlocks
warlock1636293warlock
wedlock1744553wedlock
ziplock2454413ziplock

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271107.34318252.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.54523683.4
 
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.