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 “alps” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

318 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
alps6552924(None) 
alas46358121alas
albs68628571albs
ales47067101ales
alls46740921alls
alms65834921alms
alp56641131alp_
als36663021al_s
alts46639901alts
amps86230341amps
apps86319691apps
asps65622091asps
laps66848871laps
palps94719561palps
salps74423241salps
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
ables75935542ables
abos67734412abos
abs59356072a_bs
abys97221882abys
aces67645092aces
acts66929862acts
adds67622452adds
ados57633512ados
ads49755732a_ds
agas55938842agas
ages55844592ages
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
al210674042al__
ala312463602al_a
alae45643752alae
alan46844082alan
alans55636172alans
alar46340072alar
alb57342652al_b
alba68328332alba
albas75925392albas
ale36572342al_e
alec66430062alec
alecs76620732alecs
alee46652322alee
alef76340692alef
alefs87319662alefs
aleph10311392aleph
alephs1136532alephs
alfa77624272alfa
alfas87219042alfas
alga57927602alga
algas65624932algas
alias55834602alias
alif76242132alif
alifs86121262alifs
alist56136782alist
alit46155692alit
alky115920342alky
all36148232al_l
ally76935642ally
alma66333022alma
almas76629772almas
alme65832162alme
almes75126542almes
aloe45540192aloe
aloes54933672aloes
alow75328592alow
alpha1049652alpha
alphas1139512alphas
also46423442also
alt36467962al_t
alto47831262alto
altos55822952altos
alum65227612alum
alums75720602alums
amas67746292amas
amis66445312amis
amp77541022amp_
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
anlas55626932anlas
ants47243472ants
anus47131112anus
ape57251182a_pe
apes66047432apes
apo511142122a_po
apos65433822apos
app76827602a_pp
apse67725382a_pse
apt57352542a_pt
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arles56735742arles
arms66137492arms
ars37670932a_rs
arts49650262arts
as211083072a__s
asks85721212asks
asp57235342asp_
aspis74618142aspis
ass37844062a_ss
ataps76414832ataps
ates45047922ates
atlas55821582atlas
auks85525262auks
aves76142602aves
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axis116127912axis
axles125219472axles
ayes76543512ayes
ays67050292a_ys
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
baps86040842baps
blips95615782blips
bops86037982bops
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
camps116330262camps
caps87147892caps
carps96932252carps
ceps86125952ceps
claps95626182claps
clips96018302clips
clops95924852clops
cops86751372cops
cups85430822cups
dales66439742dales
dals57145122dal_s
damps105220412damps
daps77239162daps
dips75536912dips
dups75929512dups
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722el_s
falls85727652falls
flaps105621382flaps
flips105117742flips
flops105920142flops
flus75626542flus
fops96532682fops
galas65731642galas
gales65442482gales
galls64729322galls
galops94712612galops
gals57946502gal_s
gamps105323712gamps
gaps76042972gaps
gasps85415482gasps
gawps115911012gawps
gips75632922gips
glops85619552glops
gulps84715072gulps
gyps105115022gyps
hales85449842hales
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
haps96443462haps
harps105926862harps
hasps105114642hasps
helps105219342helps
hips96433702hips
hops97942632hops
hyps125418412hyps
ilks87218572ilks
ills47030422ills
imps86221112imps
jalaps15299182jalaps
jalops15329592jalops
jaups144810532jaups
kales95730982kales
kalpa114512192kalpa
kalpas124112942kalpas
kelps115116422kelps
keps106027302keps
kips106430512kips
kops107031292kops
labs67145122labs
lacs66942482lacs
lads56549132lads
lags56546222lags
lalls55324132lalls
lamps95624832lamps
lams66552262lams
lap58565272lap_
lapis76223152lapis
lapse74917682lapse
lars46956572lars
las37281472_las
lass47444542lass
lats45962702lats
lavs76734152lavs
laws76441682laws
lays76043252lays
les35663072_les
lips67141442lips
lis37162272_lis
lops66043352lops
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
maps86141042maps
mips85534072mips
mops85940132mops
nalas55528362nalas
naps66238582naps
nips65830922nips
olds55926572olds
oles46453472oles
oops65232672oops
ops56641252_ops
pales75753802pales
palls74332562palls
palms94921752palms
palp85828572palp_
palpi95414552palpi
palpus104210282palpus
pals66951352pal_s
paps86443452paps
peps85134512peps
pips85837132pips
plops95920332plops
plus66324832plus
pops86340952pops
pulps95116482pulps
pups86032232pups
rales54947492rales
ralph1078742ralph
ralphs1135372ralphs
ramps96224632ramps
raps66247732raps
rasps74316662rasps
reps65937952reps
rips66237432rips
saleps85014902saleps
sales56055592sales
salp64534092salp_
salpa75018352salpa
salpas85116922salpas
sals46851672sal_s
salts55431882salts
samps96124672samps
saps65346372saps
scalps104315232scalps
sips65740102sips
slaps76025712slaps
slips76023722slips
slops75026012slops
sops65244562sops
sups64834432sups
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tamps95524082tamps
taps66050672taps
tarps76527112tarps
tips66436762tips
tops66248122tops
tups65628762tups
ulus45622562ulus
umps85721942umps
ups55629052_ups
urps66920472urps
vales85434262vales
vamps125415482vamps
wales86142832wales
walks126218502walks
walls85529382walls
waps96642082waps
warps107126422warps
wasps106714692wasps
wops96634152wops
yaps95933522yaps
yaups105910742yaups
yawps13628792yawps
yelps105712992yelps
yeps95924402yeps
yips95226692yips
yups96121602yups
zaps156826892zaps
zeps156019342zeps
zips155723792zips

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298723180.93631914.5
3Display Results3183180.0635047.6
 (SQL Overall)1786913181.062168258.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.