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

96 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
unstacks144604(None) 
unstack1337371unstack_
unsticks1436231unsticks
untacks1357501un_tacks
gunstocks1643232gunstocks
restacks1438092restacks
stacks124317262__stacks
unpacks1576092un_packs
unstacked1636432unstacked
unstates81314992unstates
unstick1338122unstick_
unstuck1345022unstuck_
untack1239762un_tack_
untracks1437522untracks
untucks1334672un_tucks
anticks134612253an_ticks
attacks13126943_attacks
cossacks1645223cossacks
fastbacks2044253fastbacks
gunstock1543463gunstock_
haystacks2143373haystacks
installs858923installs
instals7611713insta_ls
instances1148743instances
instants8910153instants
instars7411133insta_rs
instates81615833instates
knacks11428543kn__acks
linstocks1544143linstocks
nunataks1242183nunata_ks
penstocks1743713penstocks
ransacks1445773rans_acks
restack1339433restack_
restocks1437503restocks
retacks132210713_retacks
runbacks1655903run_backs
sacks114228873__s_acks
shacks154817563__shacks
slacks124416533__slacks
smacks144112323__smacks
snacks124514553__snacks
stack114421693__stack_
stalks104614553__stalks
stanks104917703__stanks
sticks125118613__sticks
stocks124715633__stocks
tacks115430133___tacks
umiacks1534013u_miacks
unblocks1644523unblocks
unbraces12229413unbraces
uncocks1537233un_cocks
undocks1436163un_docks
unfrocks1753843unfrocks
unifaces1346393unifaces
unitages938273unitages
unitards945623unitards
unlaces92513623un_laces
unlocks1337063un_locks
unmasks1344553un_masks
unpack1457833un_pack_
unpicks1545183un_picks
unsays9399543uns_a_ys
unseals73212573unsea_ls
unseams9338913unsea_ms
unseats73012853unsea_ts
unshackle1842763unshackle
unshackles1941993unshackles
unslick1356023unslick_
unsnags835463unsna_gs
unsnaps935423unsna_ps
unsnarls894883unsnarls
unspeaks1443593unspeaks
unstable10313763unstable
unstably1339493unstably
unstacking1744993unstacking
unstalked1435523unstalked
unstate71916213unsta_te
unstated91615813unstated
unstayed12168393unstayed
unsteels845793unsteels
unsteps936213unst_eps
unstocked1645063unstocked
unstops936993unst_ops
unstraps1045983unstraps
unstress837373unstress
untacked15239923un_tacked
untrack1338703untrack_
untuck1236403un_tuck_
upstages11147373upstages
upstairs1043643upstairs
upstands1144093upstands
upstares10178583upstares
upstarts10165273upstarts
upstates10189643upstates
uptalks1333723u_ptalks
upticks1535153u_pticks

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 Filter1786911461620.406440125.6
2DLD Change Limit146162967.03020791.2
3Display Results96960.0332909.1
 (SQL Overall)178691967.46923924.4
 
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.