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

133 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
unlocking163607(None) 
unblocking1943691unblocking
uncocking1836231uncocking
undocking1735651undocking
blocking174510572_blocking
clocking174312412_clocking
flocking183410872_flocking
knocking14245942kn_ocking
locking143718152__locking
nocking143615112_n_ocking
onlooking1444452onlooking
relocking16137682relocking
uncloaking1784852uncloaking
uncorking1637402uncorking
unfrocking2043532unfrocking
unhooking1735352unhooking
unlacing1148652unlac_ing
unlinking1436272unlinking
unloading1137192unloading
unloosing1036112unloosing
unloving1277482unlo_ving
unpacking1835132unpacking
unpicking1834882unpicking
untacking1636642untacking
untucking1644692untucking
unyoking1636182unyo_king
anticking1649243anticking
bemocking2034653bemocking
blacking174213603_blacking
chocking204011013_chocking
clacking173313493_clacking
clicking173610983_clicking
cloaking15299713_cloaking
clonking153810153_clonking
clucking17429993_clucking
cocking163619983__cocking
crocking174313443_crocking
docking153615013__docking
enlacing1148773enlac_ing
flacking184311793_flacking
flecking18408233_flecking
flicking184110043_flicking
floccing16306033_floccing
flockings19314343_flockings
frocking18309573_frocking
havocking2242773havocking
hocking173417243__hocking
hummocking24101863hummocking
inlacing1158373inlac_ing
invoking1635653invo_king
knacking14296713kn_acking
lacking143821543__lacking
licking144118283__licking
locoing102810973__locoing
looking123415043__looking
lucking143615833__lucking
mocking163614453__mocking
necking143913893_n_ecking
nicking143516323_n_icking
onloading1145163onloading
outrocking1747053outrocking
padlocking2043023padlocking
plonking15358563_plonking
plucking17357723_plucking
pocking163916763__pocking
recocking18138373recocking
redocking17126783redocking
relooking14167143relooking
rocking143619633__rocking
shocking184311543_shocking
shylocking2342513shylocking
slacking153914133_slacking
slicking153712593_slicking
smocking17349103_smocking
snacking153411703sn_acking
snicking153610233sn_icking
snooking133010583sn_ooking
socking143518603__socking
stocking152912503_stocking
talcking1567083tal_cking
trocking153612423_trocking
unblinking1743923unblinking
unbolting1236453unbolting
unbowing1436993unbo_wing
unboxing1836113unbo_xing
unbraking1636933unbraking
unbuckling1942363unbuckling
uncaking1539463un_caking
unchoking1935703unchoking
unclogging1543543unclogging
unclosing1247753unclo_sing
unclothing1644133unclothing
unclouding1444523unclouding
uncloying1555813unclo_ying
uncoating12611923uncoating
uncoiling1238993uncoiling
undoing9312243undo__ing
unfolding1436063unfolding
ungloving1444713unglo_ving
unhooding1435893unhooding
unhorsing1336853unhorsing
unhousing1335883unhousing
unhusking1744093unhusking
unkinking1334783unkinking
unlading1058863unl_ading
unlashing1336493unlashing
unlatching1643153unlatching
unlaying1258363unl_aying
unleading1138673unleading
unliving1248193unl_iving
unlock1248533unlock___
unlocked15268383unlock_ed
unlocks1337063unlock__s
unluckier1541933unluckier
unluckily1841753unluckily
unmaking1538133un_making
unmasking1635263unmasking
unmolding1335823unmolding
unmooring1255813unmooring
unmoving1436253unmo_ving
unquaking2354593unquaking
unrobing1138063unro_bing
unrolling1078563unrolling
unroofing1385703unroofing
unrooting1098833unrooting
unstacking1744993unstacking
unsticking1744943unsticking
untracking1746933untracking
unvoicing1545083unvoicing
unwinking1735073unwinking
uplinking1634623uplinking
uploading1334663uploading
yocking173712373__yocking

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411337.23620541.9
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.68823242.8
 
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.