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

86 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
gunlock144456(None) 
gunlocks1544681gunlocks
unlock1248531_unlock
bullock1537192bullock
gunstock1543462gunstock
mullock1535712mullock
sunblock1643762sunblock
unblock1545792_unblock
uncock1438562_uncock
undock1337702_undock
unlocks1337062_unlocks
armlock1544313armlock
bannock1545043bannock
block134917843__block
bonnock1545203bonnock
bullocks1636293bullocks
bullocky1943643bullocky
burdock1644603burdock
buttock1545563buttock
clock134917983__clock
daglock1544263daglock
earlock1336923earlock
elflock1642973elflock
fetlock1645323fetlock
flock144717423__flock
futtock1644153futtock
gavelock1843013gavelock
gorcock1643653gorcock
gridlock1642863gridlock
guck114922533gu___ck
gulch113810603gu_l_ch
gunboat1047363gunboat
gundog935793gundo_g
gundogs1034603gundogs
gunk95423573gun___k
gunless8299633gunless
gunroom1045053gunroom
gunstocks1643233gunstocks
hemlock1845633hemlock
hillock1646693hillock
hummock2063793hummock
killock1255253killock
knock10487963_kn_ock
lock106134363___lock
mudrock1644353mudrock
mullocks1645033mullocks
mullocky1942813mullocky
nock106127183__n_ock
oarlock1336123oarlock
outlook1138023outlook
outrock1339303outrock
padlock1665813padlock
pollock1546843pollock
relock124713523_relock
rowlock1654783rowlock
ruddock1543133ruddock
runback1556603runback
schlock18235873schlock
shlock15378193_shlock
shylock1945053shylock
subblock1843673subblock
sunback1548153sunback
sunblocks1743413sunblocks
sundeck1445273sundeck
tussock1343833tussock
unblocks1644523_unblocks
uncloak1365473_uncloak
uncocks1537233_uncocks
uncork1239043_uncork
undocks1436163_undocks
unfrock1674633_unfrock
unhook1347523_unhook
unlace82215173_unlace
unlink104011013_unlink
unload73010803_unload
unlocked15268383_unlocked
unlucky1643223_unlucky
unpack1457833_unpack
unpick1446903_unpick
unslick1356023_unslick
untack1239763_untack
untuck1236403_untuck
warlock1636293warlock
wedlock1744553wedlock
winnock1643893winnock
ziplock2454413ziplock

Search took 7 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.390458182.1
2DLD Change Limit134027866.44020811.6
3Display Results86860.0302866.7
 (SQL Overall)178691866.86026048.3
 
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.