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

187 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
unstop83747(None) 
unstep839221unstep
unstops936991unstops
estop74312102_estop
instep838192instep
netop7312342_netop
nonstop9106922nonstop
postop10511942postop
stop66532032__stop
unship1148032unship
unshod1067602unshod
unsnap836202unsnap
unsteps936212unsteps
unstrap946782unstrap
unto45824282un_to_
upstep1035502upstep
atop66124753__atop
bestow1149463bestow
bishop1336943bishop
boston8513043boston
cartop104213563cartop
castor84418533castor
cestoi84511953cestoi
cestos84718093cestos
custom104010273custom
custos84014313custos
desktop1442413desktop
dustup935363dustup
estops84011223_estops
functor1235203functor
gunship1345383gunship
gunshot1156643gunshot
gunstock1543463gunstock
gusto65414643gusto_
hyssop1443413hyssop
instal6712193instal
instar6310013instar
insteps936573insteps
instil61111383instil
into45026153in_to_
junto125114563jun_to_
juntos134110843jun_tos
knop107116593kn__op
laptop1076813laptop
misstop11156413misstop
munster93710523munster
nestor63713423nestor
netops839213_netops
niton55418283_niton
nonstops10116883nonstops
nostoc868193nostoc
onto46127663on_to_
pastor84817483pastor
pesto75723723pesto_
pestos84719083pestos
pistol83313333pistol
piston83515923piston
pistou83211843pistou
postops11311713postops
punster92911103punster
punto75121323pun_to_
puntos85915793pun_tos
questor16146633questor
ragtop936683ragtop
redtop937973redtop
ripstop1174763ripstop
scop85925523__scop
shop95629843__shop
slop66533873__slop
snoop75317173sn_oop
sop57557863__s_op
step67126293__step
stoa45425913__stoa
stob66724613__stob
stomp95616663__stomp
stoop75821543__stoop
stope74727243__stope
stops74827283__stops
stopt76528353__stopt
stot46347333__stot
stoup75517073__stoup
stow77325743__stow
stowp105614233__stowp
strop77422243__strop
sunspot947163sunspot
sunstone847793sunstone
swop95120503__swop
sysop1037193sys_op
teston6313303teston
tiptop1036103tiptop
top510560683___top
ulster63712103ulster
unbox1438753un_box
uncap9312283un_cap
unclip1046993unclip
unclog956603unclog
unco66021403un_co_
uncool8610113uncool
uncos74117033un_cos
uncoy104111413un_coy
unction9310663unction
undo55620153un_do_
ungot61718063un_got
unhip10178823un_hip
unhood1039233unhood
unhook1347523unhook
union54519793un_ion
unipod946853unipod
unison649033unison
unit45140073unit__
unite54828383unit_e
united74421543united
uniter64619143uniter
unites65024853unites
units54923433unit_s
unity84918493unit_y
unknot1037413unknot
unmoor836313unmoor
unrip72012863un_rip
unroof9410193unroof
unroot6315553unroot
uns35936753uns___
unsafe9310693unsafe
unsaid7411833unsaid
unsated83419933unsated
unsawn9317463unsawn
unsay83212843uns_ay
unsays9399543unsays
unseal63315473unseal
unseam83313143unseam
unseat64221023unseat
unseen62012623unseen
unsell63512543unsell
unsent63820963unsent
unset54532433uns_et
unsets64116163unsets
unsew83912693uns_ew
unsewn9298393unsewn
unsews9379363unsews
unsex123512633uns_ex
unsexy16296903unsexy
unsharp1235543unsharp
unshed10313773unshed
unships1237203unships
unshorn1036943unshorn
unshowy1644173unshowy
unshut939013unshut
unsnag736393unsnag
unsnaps935423unsnaps
unsold71410513unsold
unsown9328433unsown
unspoke1336573unspoke
unspool945163unspool
unspun865793unspun
unstack1337373unstack
unstate71916213unstate
unsteel738793unsteel
unstick1338123unstick
unstoned9311043unstoned
unstopped1444403unstopped
unstopper1343523unstopper
unstraps1045983unstraps
unstuck1345023unstuck
unstung834853unstung
unsung736983unsung
unsunk1036333unsunk
unsure62815413unsure
unswept1246013unswept
unswore1039053unswore
unsworn1046843unsworn
untie54425493un_tie
until53517743un_til
untold7149683un_told
untorn63012343un_torn
untrod769853untrod
unwon84512343un_won
unwrap11126323unwrap
unzip16207623un_zip
upprop944093upprop
upshot1138453upshot
upslope1144173upslope
upsteps1133743upsteps
upstir835383upstir
upstood1044243upstood
usurp7106903u_surp
xystoi16365133xystoi
xystos16356913xystos

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127161875.53020382.6
3Display Results1871870.0632968.3
 (SQL Overall)1786911875.95330017.0
 
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.