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

173 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
unpicks154518(None) 
unpacks1576091unpacks
unpick1446901unpick_
anticks134612252anticks
nicks114920492_n_icks
nutpicks1643422nutpicks
picks135226142__picks
snicks124312472sn_icks
spicks144814992_spicks
uncocks1537232uncocks
undocks1436162undocks
unkinks10265412unkinks
unlinks11307402unlinks
unlocks1337062unlocks
unpack1457832unpack_
unpicked17237212unpicked
unpiles92112782unpiles
unpins82312382unpi_ns
unsticks1436232unsticks
untacks1357502untacks
untucks1334672untucks
upticks1535152upticks
antick124814583antick_
antics84621453antic_s
apices104916263_apices
aspics104211563aspic_s
auspices1236443auspices
bipacks1745043bipacks
bricks144614623_bricks
chicks175317593_chicks
clicks145315113_clicks
copecks1745873copecks
cricks144316053_cricks
depicts12358463depicts
deticks1437353deticks
dicks125824693__dicks
entices91616333entices
epics95014283_epic_s
flicks154512993_flicks
gunlocks1544683gunlocks
handpicks2143233handpicks
henpecks1942873henpecks
hicks145322173__hicks
hoicks15378283_hoicks
indices103513443indices
indicts103210723indicts
kicks104420083__kicks
klicks11468723_klicks
knacks11428543kn_acks
knocks11397443kn_ocks
kopecks1433073kopecks
licks115325393__licks
medicks16368413medicks
micks135525373__micks
mudpacks1943233mudpacks
musicks15297053musicks
necks115119333_n_ecks
nick106627603_n_ick_
nitpicks1643183nitpicks
nocks115121013_n_ocks
nubucks1544003nubucks
nudnicks1542403nudnicks
nutpick1543883nutpick_
outkicks1344603outkicks
packs135528933__packs
pecks135724433__pecks
picas94626523__picas
pick125933813__pick_
picky165416943__picky
pics85633913__pic_s
pinks115729383__pinks
pinpricks1942763pinpricks
pocks135022963__pocks
pricks144414263_pricks
pucks134322103__pucks
quicks21389303_quicks
repacks15269543repacks
ricks115126133__ricks
runbacks1655903runbacks
shticks16356963shticks
sicks115127623__sicks
slicks124816113_slicks
snacks124514553sn_acks
snecks124410033sn_ecks
snick114416013sn_ick_
specks144312703_specks
spicas104715823_spicas
spices104326033_spices
spick134519073_spick_
spics94123243_spic_s
spiks114117473_spi_ks
sticks125118613_sticks
stricks134310693stricks
sundecks1544253sundecks
thicks154511993_thicks
ticks115823293__ticks
topics104714583topic_s
topkicks1542633topkicks
tricks125319013_tricks
tunics83811263tun_ic_s
tupiks1235493tupi_ks
umiacks1534013umiacks
umiaks1244953u_miaks
umpires1137813umpires
unais53420773unai__s
unbinds10267353unbinds
unblocks1644523unblocks
uncials92510523uncials
uncinus937403uncinus
uncock1438563uncock_
uncorks1337443uncorks
uncos74117033un__cos
uncus74014983un__cus
undies73821963undi_es
undines8716083undines
undock1337703undock_
unfits93910293unfi_ts
unfixes17238113unfixes
unfrocks1753843unfrocks
ungirds9105303ungirds
unhooks1436413unhooks
unhusks1443263unhusks
unions64216753un_ions
unipods1095703unipods
unites65024853un_ites
units54923433un_i_ts
unkink9308713unkink_
unlaces92513623unlaces
unlicked15248263unlicked
unlike102614063unli_ke
unlink104011013unlink_
unlives102010953unlives
unlock1248533unlock_
unlucky1643223unlucky
unmasks1344553unmasks
unmixes16197753unmixes
unpacked17268663unpacked
unpacker16215893unpacker
unpackers17203813unpackers
unpegs9256233unp_egs
unpens82511013unp_ens
unpicking1834883unpicking
unpile81914323unpi_le
unpiled102312743unpiled
unpin72613243unpi__n
unplugs1042983unplugs
unpriced1338143unpriced
unpucker16234273unpucker
unpuckers17243123unpuckers
unrigs7159003unri_gs
unrips8199453unri_ps
unsicker1435303unsicker
unslick1356023unslick_
unspeaks1443593unspeaks
unstacks1446043unstacks
unstick1338123unstick_
untack1239763untack_
unthinks1574503unthinks
unties64326923unti_es
untracks1437523untracks
untuck1236403untuck_
unvoices13125163unvoices
unwinds11286733unwinds
unwits9389893unwi_ts
unzips17175273unzi_ps
uplinks13345613uplinks
uppiles11208263uppiles
uppings12257123uppings
uptick1436763uptick_
wicks144619363__wicks
wricks154610623_wricks
yapocks18354723yapocks
yoicks15375933_yoicks

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.1701051123.5
2DLD Change Limit1340271736.89319443.9
3Display Results1731730.0602883.3
 (SQL Overall)1786911737.12325086.5
 
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.