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

237 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
unlicked1524826(None) 
unliked122411281unli_ked
unlinked13237791unlinked
unlocked15268381unlocked
unpicked17237211unpicked
anticked1538392anticked
clicked164112452_clicked
flicked174610672_flicked
licked134621562__licked
nicked135019682_n_icked
slicked144413842_slicked
snicked143811632sn_icked
unbacked17268732unbacked
unblocked1864352unblocked
uncliched1744622uncliched
uncocked17248752uncocked
undecked16238492undecked
undocked16277632undocked
unkinked12215902unkinked
unlaced102913732unlac_ed
unlike102614062unli_ke_
unlined82515802unli_ned
unlisted9311152unlisted
unlived112511372unli_ved
unpacked17268662unpacked
unplucked1843572unplucked
unsicker1435302unsicker
unsliced1138092unslic_ed
untacked15239922untacked
untucked15206052untucked
uplinked15254202uplinked
blacked163613373_blacked
blinked144010013_blinked
blocked16449983_blocked
bricked164312063_bricked
clacked164113603_clacked
cliched153711023_cliched
clicker154111883_clicker
clinked144011643_clinked
clocked164112833_clocked
clucked163810133_clucked
cricked164814283_cricked
curlicued1442133curlicued
deticked1635693deticked
dicked144920863__dicked
enlaced102410523enlac_ed
enlisted978193enlisted
enriched1435863enriched
enticed101411193entic_ed
flacked173711583_flacked
flecked17358073_flecked
flicker163610623_flicker
flocked174510253_flocked
frolicked1942613frolicked
garlicked1772883garlicked
hoicked1735963_hoicked
indicted1249203indicted
inflicted1545533inflicted
inlaced10239873inlac_ed
kicked124415943__kicked
knacked13287793kn_acked
knocked13236303kn_ocked
lacked135324653__lacked
licker125222043__licker
liked104523813__li_ked
linked114518213__linked
locked134921663__locked
lucked135118023__lucked
magicked1842963magicked
mimicked1943253mimicked
musicked1734033musicked
necked134715063_n_ecked
niched125514063_n_iched
nickel123811343_n_ickel
nicker123818703_n_icker
nickled144010443_n_ickled
nocked134617383_n_ocked
nunlike11258073nunli_ke_
outkicked1544173outkicked
outslicked1743203outslicked
panicked1785173panicked
picked154421313__picked
plinked143910893_plinked
plucked16367963_plucked
policed123212233polic_ed
pricked164613833_pricked
relinked1337003relinked
relocked15217743relocked
ricked136523623__ricked
rollicked1643033rollicked
sicked134524403__sicked
slacked143815453_slacked
sliced94416313_slic_ed
slicken13309293_slicken
slicker133314533_slicker
slinked123011383_slinked
snacked144013113sn_acked
snicker133012673sn_icker
spliced124310593splic_ed
sticked144114633_sticked
sunlike112310573sunli_ke_
talcked1446343tal_cked
ticked134720523__ticked
tricked144016163_tricked
uglified1345293uglified
unacted10312733un_acted
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unaligned1144873unaligned
unalike11311533unali_ke_
unarched14128553unarched
unasked122010023un_asked
unawaked1635903unawaked
unbaked143312893un_baked
unbiased1147153unbiased
unbilled1188693unbilled
unbitted1138213unbitted
unblinded13295233unblinded
unbraked15289413unbraked
unbuckled1843633unbuckled
uncaked143514353un_caked
uncasked15278453uncasked
unchecked2144063unchecked
unchoked18257623unchoked
unclinched1842653unclinched
unclipped1643843unclipped
uncloaked1635653uncloaked
uncooked15269113uncooked
uncorked152210403uncorked
uncracked18226803uncracked
undimmed1434113undimmed
unelected1237823unelected
unfaked153211173un_faked
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218293unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unforked16218953unforked
unfrocked1944223unfrocked
ungifted13116833ungifted
ungirded1136083ungirded
unhinged13257473unhinged
unhired112512153unhi_red
unhitched1843093unhitched
unhooked16286743unhooked
unhusked1634603unhusked
unified112413573un_ified
unilobed1136393unilobed
united74421543un_i_ted
unkissed1334893unkissed
unlace82215173unlac_e_
unlaces92513623unlac_es
unladed92614373unl_aded
unlashed12289183unlashed
unlatched1544213unlatched
unleaded10411333unleaded
unleased9310713unleased
unled64021073unl___ed
unletted9310313unletted
unlevied1236843unlevied
unlicensed1343023unlicensed
unlighted1455783unlighted
unlikely1543823unli_kely
unlimber1243373unlimber
unlimited1245923unlimited
unlink104011013unlink__
unlinks11307403unlink_s
unlive92712333unli_ve_
unlives102010953unli_ves
unloaded1049533unloaded
unlobed10219743unl_obed
unlocated1238383unlocated
unlock1248533unlock__
unlocks1337063unlock_s
unloosed9117523unloosed
unloved112310533unl_oved
unluckier1541933unluckier
unlucky1643223unluck_y
unmarked15248813unmarked
unmasked15267143unmasked
unmilled1197853unmilled
unmined102612953unmi_ned
unmitred1136843unmitred
unmixed17228213unmi_xed
unoiled82415483unoi_led
unpacker16215893unpacker
unpick1446903unpick__
unpicks1545183unpick_s
unpiled102312743unpi_led
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unplaced1338613unplac_ed
unpoliced1445163unpolic_ed
unpriced1338143unpric_ed
unpucker16234273unpucker
unraked122914013un_raked
unranked1338563unranked
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unslaked1338463unslaked
unslick1356023unslick__
unsmoked1536013unsmoked
unsoaked1338853unsoaked
unstacked1636433unstacked
unstocked1645063unstocked
untidied1038903untidied
untied73720813unti__ed
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untitled978763untitled
untracked16228373untracked
unvoiced14106303unvoic_ed
unwilled1277823unwilled
unwished15237833unwished
unwitted1237543unwitted
unworked16238503unworked
unyoked1567123un_yoked
unzipped2233213unzipped
uplifted1454423uplifted
urnlike1136713urnli_ke_
wicked164317413__wicked
wricked174910193_wricked

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622376.39022873.6
3Display Results2372370.1102154.5
 (SQL Overall)1786912376.92325811.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.