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

194 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
unpacks157609(None) 
unpack1457831unpack_
unpicks1545181unpicks
untacks1357501untacks
bipacks1745042bipacks
knacks11428542kn_acks
mudpacks1943232mudpacks
packs135528932__packs
repacks15269542repacks
runbacks1655902runbacks
snacks124514552sn_acks
umiacks1534012umiacks
uncocks1537232uncocks
undocks1436162undocks
unlaces92513622unlaces
unlocks1337062unlocks
unmasks1344552unmasks
unpacked17268662unpacked
unpacker16215892unpacker
unpackers17203812unpackers
unpick1446902unpick_
unstacks1446042unstacks
untack1239762untack_
untracks1437522untracks
untucks1334672untucks
alpacas1137073alpacas
anlaces92313733anlaces
anticks134612253anticks
arracks1387733arracks
attacks13126943attacks
backs135729623__backs
bipack1636523bipack_
blacks144914953_blacks
buybacks2144783buybacks
calpacks18266523calpacks
caracks152211563caracks
clacks144516343_clacks
copecks1745873copecks
cracks144817003_cracks
cutbacks1845813cutbacks
enacts84012973en_acts
enfaces122110913enfaces
enlaces92313393enlaces
epacts105010393_epacts
finbacks1965363finbacks
flacks154114533_flacks
gunlocks1544683gunlocks
hacks144928713__hacks
henpecks1942873henpecks
hijacks2333533hijacks
hopsacks1944733hopsacks
humpbacks2443173humpbacks
impacts13266503impacts
imparks15276663imparks
inlaces92512903inlaces
jacks185219833__jacks
knack104311043kn_ack_
knapsacks1641983knapsacks
knocks11397443kn_ocks
kopecks1433073kopecks
kyacks14416063_kyacks
lacks116129203__lacks
macks135127603__macks
manpack1746063manpack_
mudpack1843593mudpack_
narks96026033_n_arks
necks115119333_n_ecks
nicks114920493_n_icks
nocks115121013_n_ocks
nubucks1544003nubucks
nutpicks1643423nutpicks
outbacks1638983outbacks
outpaces122411943outpaces
pacas96029403__pacas
paces96741113__paces
pack125535443__pack_
pacs85842183__pac_s
pacts95125803__pacts
paiks114719853__paiks
parks116134463__parks
pecks135724433__pecks
picks135226143__picks
placks144414153_placks
pocks135022963__pocks
prepacks1836583prepacks
pucks134322103__pucks
quacks214710103_quacks
racks115028853__racks
ransacks1445773ransacks
repack142412163repack_
reparks13249513reparks
reracks132310533reracks
retacks132210713retacks
runback1556603runback_
sacks114228873__sacks
shacks154817563_shacks
slacks124416533_slacks
smacks144112323_smacks
snack114718063sn_ack_
snapbacks1954303snapbacks
snarks104815733sn_arks
sneaks104312493snea_ks
snecks124410033sn_ecks
snicks124312473sn_icks
snowpacks2042593snowpacks
spaces104722633_spaces
spanks124514123_spanks
sparks124616363_sparks
specks144312703_specks
spicks144814993_spicks
stacks124317263_stacks
sunback1548153sunback_
sundecks1544253sundecks
tacks115430133__tacks
thacks154311923_thacks
thwacks1953613thwacks
tracks124818843_tracks
tripacks1664893tripacks
umiack1435173umiack_
umiacs1035663umiac_s
umiaks1244953umia_ks
unais53420773un_a_is
unarms839243un_arms
unaus53216573un_a_us
unbacked17268733unbacked
unbales92914863unbales
unbans81912623unba_ns
unbars82113033unba_rs
unblocks1644523unblocks
unbraces12229413unbraces
uncages103213773uncages
uncake122813523unca_ke
uncakes133012743uncakes
uncaps1039813unca_ps
uncases93516553uncases
uncock1438563uncock_
uncorks1337443uncorks
uncos74117033un__cos
uncus74014983un__cus
undock1337703undock_
uneases73316263uneases
unfrocks1753843unfrocks
unhairs1036373unhairs
unhands1137773unhands
unhangs1136203unhangs
unhats91110623unha_ts
unhooks1436413unhooks
unhusks1443263unhusks
unifaces1346393unifaces
unjams1555703unja_ms
unkinks10265413unkinks
unlace82215173unlac_e
unlaced102913733unlaced
unlades82612833unlades
unlays93810493unla_ys
unlinks11307403unlinks
unlock1248533unlock_
unlucky1643223unlucky
unmacho1443923unmacho
unmake122811213unma_ke
unmakes132810793unmakes
unmans82211993unma_ns
unmask1265903unmask_
unnails738223unnails
unpacking1835133unpacking
unpaged113311043unpaged
unpaid939473unpa_id
unpaved133410053unpaved
unpegs9256233unp_egs
unpens82511013unp_ens
unpicked17237213unpicked
unpiles92112783unpiles
unpins82312383unp_ins
unplaced1338613unplaced
unplaits1044813unplaits
unplugs1042983unplugs
unpucker16234273unpucker
unpuckers17243123unpuckers
unsays9399543unsa_ys
unspeaks1443593unspeaks
unstack1337373unstack_
unsticks1436233unsticks
untacked15239923untacked
untrack1338703untrack_
untuck1236403untuck_
upas68322383u_pa__s
upases84112903u_pases
uptalks1333723uptalks
upticks1535153upticks
wacks146626283__wacks
whacks184610483_whacks
wracks154711113_wracks
yacks144419813__yacks
yapocks18354723yapocks

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.406440125.6
2DLD Change Limit1340271946.20321606.8
3Display Results1941940.0633079.4
 (SQL Overall)1786911946.67226782.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.