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

130 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
unstack133737(None) 
unstacks1446041unstacks
unstick1338121unstick
unstuck1345021unstuck
untack1239761un_tack
gunstock1543462gunstock
restack1339432restack
stack114421692__stack
unpack1457832un_pack
unslick1356022unslick
unstacked1636432unstacked
unstate71916212unstate
unsticks1436232unsticks
untacks1357502un_tacks
untrack1338702untrack
untuck1236402un_tuck
antick124814583an_tick
attack12148153_attack
cossack1545823cossack
eustacy1254663eustacy
fastback1944523fastback
gunstocks1643233gunstocks
haystack2044013haystack
instal6712193insta_l
install779363install
instals7611713instals
instance1049883instance
instancy1346573instancy
instant7815343instant
instar6310013insta_r
instars7411133instars
instate71616483instate
intact8314663in_tact
knack104311043kn__ack
linstock1444433linstock
nonstick1447593nonstick
nunatak1142673nunata_k
onstage838363onstage
penstock1644073penstock
ransack1346463rans_ack
restacks1438093restacks
restock1338673restock
retack122612823_retack
runback1556603run_back
sack105337313__s_ack
shack145321753__shack
slack115021763__slack
smack134615453__smack
snack114718063__snack
stacks124317263__stacks
stalk94518003__stalk
stank95823303__stank
stark95425623__stark
stick115121563__stick
stock114417563__stock
stuck114515773__stuck
sunback1548153sun_back
sunstruck1552583sunstruck
tack106536293___tack
testacy1235963testacy
umiack1435173u_miack
unblock1545793unblock
unbrace111910493unbrace
uncock1438563un_cock
undock1337703un_dock
unfrock1674633unfrock
uniface1236953uniface
unitage838993unitage
unitard838003unitard
unitary1038613unitary
unlace82215173un_lace
unlatch1245053unlatch
unlock1248533un_lock
unmask1265903un_mask
unpacks1576093un_packs
unpick1446903un_pick
unsafe9310693uns_afe
unsaid7411833uns_aid
unsated83419933unsated
unsawn9317463uns_awn
unsay83212843uns_a_y
unsays9399543uns_ays
unseal63315473unsea_l
unseals73212573unseals
unseam83313143unsea_m
unseams9338913unseams
unseat64221023unsea_t
unseats73012853unseats
unshackle1842763unshackle
unsharp1235543unsharp
unsmart939603unsmart
unsnag736393unsna_g
unsnags835463unsnags
unsnap836203unsna_p
unsnaps935423unsnaps
unsnarl7107153unsnarl
unsoncy1245513unsoncy
unspeak1344793unspeak
unstable10313763unstable
unstably1339493unstably
unstacking1744993unstacking
unstalked1435523unstalked
unstated91615813unstated
unstates81314993unstates
unstayed12168393unstayed
unsteady1243513unsteady
unsteel738793unsteel
unstep839223unst_ep
unsteps936213unsteps
unstitch1343593unstitch
unstocked1645063unstocked
unstop837473unst_op
unstops936993unstops
unstrap946783unstrap
unstraps1045983unstraps
unstung834853unstung
unsunk1036333uns_unk
untacked15239923un_tacked
untame82513603un_tame
unteach1246143unteach
untracks1437523untracks
untucks1334673un_tucks
upstage10167443upstage
upstair943983upstair
upstand1045343upstand
upstare9158683upstare
upstart9159753upstart
upstate91610493upstate
uptalk1234653u_ptalk
uptick1436763u_ptick

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.423422437.4
2DLD Change Limit1340271306.98319193.3
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.45223978.9
 
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.