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

164 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
unstops93699(None) 
unsteps936211unsteps
unstop837471unstop_
estops84011222_estops
insteps936572insteps
netops839212_netops
nonstops10116882nonstops
postops11311712postops
stops74827282__stops
unships1237202unships
unsnaps935422unsnaps
unstep839222unstep_
unstraps1045982unstraps
upsteps1133742upsteps
bestows1248863bestows
bishops1437033bishops
bostons9312903bostons
castors94919443castors
cestos84718093cesto_s
customs11348263customs
custos84014313custo_s
desktops1542463desktops
dustups1033913dustups
estop74312103_estop_
functors1335743functors
gunships1445173gunships
gunshots1244373gunshots
gunstock1543463gunstock
gunstocks1643233gunstocks
gustoes879873gustoes
hyssops1543123hyssops
instals7611713instals
instars7411133instars
instep838193instep_
instils7811453instils
juntos134110843jun_to_s
knops115911813kn__ops
laptops1166603laptops
misstops12176413misstops
munsters104010553munsters
nestors73614973nestors
netop7312343_netop_
nitons64614903_nitons
nonstop9106923nonstop_
nostocs947553nostocs
pastors94119003pastors
pestos84719083pesto_s
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
postop10511943postop_
psyops1334343_psyops
punsters103310583punsters
puntos85915793pun_to_s
questors17147013questors
ragtops1035453ragtops
redtops1037373redtops
ripstops1265013ripstops
scops95820193__scops
shops104222903__shops
slops75026013__slops
snoops84314173sn_oops
sops65244563__s_ops
steps76619883__steps
stoas55126023__stoas
stobs75718233__stobs
stomps105612833__stomps
stoops85917893__stoops
stop66532033__stop_
stope74727243__stope
stopes84525893__stopes
stopt76528353__stopt
stoss54316343__stoss
stots54828553__stots
stoups85313273__stoups
stowps115710583__stowps
stows86622703__stows
strops86220383__strops
sundrops1145823sundrops
sunspots1045083sunspots
sunstone847793sunstone
sunstones947883sunstones
swops105913973__swops
sysops1136013sys_ops
testons7313563testons
tiptops1136073tiptops
tops66248123___tops
ulsters72711983ulsters
uncaps1039813un_caps
unclips1136433unclips
unclogs1036803unclogs
uncos74117033un_co_s
uncross938193uncross
unctions1039733unctions
unctuous1044853unctuous
undoes73917403un_does
unhoods1137503unhoods
unhooks1436413unhooks
unions64216753un_ions
unipods1095703unipods
unisons748423unisons
uniters73814173uniters
unites65024853unit_es
unities72520153unities
units54923433unit__s
unknots1144303unknots
unmoors945903unmoors
unrips8199453un_rips
unroofs1035783unroofs
unroots738563unroots
unsays9399543uns_ays
unseals73212573unseals
unseams9338913unseams
unseats73012853unseats
unsells73210773unsells
unsets64116163uns_ets
unsews9379363uns_ews
unsexes14248923unsexes
unship1148033unship_
unshod1067603unsho_d
unshorn1036943unshorn
unshowy1644173unshowy
unsnags835463unsnags
unsnap836203unsnap_
unsold71410513uns_old
unsonsy1045023uns_onsy
unsown9328433uns_own
unspoke1336573unspoke
unspool945163unspool
unspools1043693unspools
unstack1337373unstack
unstacks1446043unstacks
unstate71916213unstate
unstates81314993unstates
unsteel738793unsteel
unsteels845793unsteels
unstick1338123unstick
unsticks1436233unsticks
unstoned9311043unstoned
unstopped1444403unstopped
unstopper1343523unstopper
unstoppers1442673unstoppers
unstrap946783unstrap
unstress837373unstress
unstuck1345023unstuck
unstung834853unstung
unswept1246013unswept
unswore1039053unswore
unsworn1046843unsworn
unties64326923un_ties
unto45824283un_to__
untold7149683un_told
untorn63012343un_torn
unwraps1255513unwraps
unzips17175273un_zips
upprops1044223upprops
upshots1235193upshots
upslope1144173upslope
upstep1035503upstep_
upstirs935293upstirs
upstood1044243upstood
uptoss836093u_ptoss
usurps8105073u_surps
xystos16356913xysto_s

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 Limit1340271646.48320673.6
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.95225703.5
 
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.