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

284 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
aloe4554019(None) 
alae45643751alae
ale36572341al_e
alee46652321alee
alme65832161alme
aloes54933671aloes
alone55732961alone
alow75328591alow
floe76129771floe
sloe45534951sloe
abbe87627192abbe
able66340532able
abo59045962abo_
abode85518812abode
abos67734412abos
above105414322above
abye97921002abye
ace59656832a_ce
ache96829822ache
acme86924322acme
acne66625872acne
acre67330772acre
ado49146872ado_
adobe84814712adobe
adore65723672adore
ados57633512ados
adoze155713832adoze
adze1412820572adze
ae212590292a__e
aeon45634612aeon
afore85818602afore
age47154332a_ge
agee56241492agee
aglee65728492aglee
aglow94711972aglow
ago48845522ago_
agog68019002agog
agon56531882agon
agone65924552agone
ague55725922ague
ahoy101919182ahoy
aide56045002aide
ajee115928232ajee
akee85936812akee
al210674042al__
ala312463602al_a
alan46844082alan
alane56135612alane
alar46340072alar
alas46358122alas
alate55340332alate
alb57342652al_b
alba68328332alba
albs68628572albs
alcove1178092alcove
alder65421912alder
aldol61212332aldol
aldose7311092aldose
alec66430062alec
alef76340692alef
ales47067102ales
alfa77624272alfa
alga57927602alga
algae65319622algae
algor6513052algor
alien56425582alien
alif76242142alif
alike95523962alike
aline57243152aline
alit46155692alit
alive85722512alive
alkie95520032alkie
alky115920342alky
all36148232al_l
allee54932122allee
alley85721672alley
allod64418382allod
allot54933872allot
allow85420662allow
alloy85519972alloy
alls46740922alls
ally76935642ally
alma66333022alma
almeh106214552almeh
almes75126542almes
alms65834922alms
aloft8423432aloft
aloha8513622aloha
aloin55227422aloin
along65419492along
aloof83521572aloof
aloud65018072aloud
alp56641132al_p
alps65529242alps
als36663022al_s
also46423442also
alt36467962al_t
alter54828502alter
alto47831262alto
altos55822952altos
alts46639902alts
alum65227612alum
amie66339852amie
amok10217402amok
amole75724592amole
ane37866952a_ne
anoa45634472anoa
anode65021042anode
anole55330382anole
anon46134852anon
ante46538902ante
ape57251182a_pe
apo511142122apo_
apod78123182apod
apos65433822apos
apse67725382apse
are37874572a_re
arose55832082arose
arse46539272arse
aslope839012aslope
ate37059242a_te
atom67824522atom
atone56527982atone
atop66124752atop
ave67748702a_ve
avo68936232avo_
avos77227012avos
avow107816462avow
awe67746622a_we
awee76336642awee
awoke124912002awoke
awol75620672awol
axe108239492a_xe
axle116424602axle
axon115524302axon
axone125918472axone
aye67151762a_ye
azlon144312872azlon
azo128233392azo_
azole145118032azole
azon135725052azon
azote144416342azote
bale66353842bal_e
blae66134642blae
blob86027092blob
bloc85023272bloc
blog75723822blog
bloke114316632bloke
blot65842322blot
blow95827192blow
blue65328462blue
bole66448692bole
calo64936442calo_
calos74431902calos
calve105919922calve
canoe75627252canoe
clod76124612clod
clog76123242clog
clon66232482clon
clone75728162clone
clop86929892clop
close76425222close
clot66542422clot
clove105619442clove
cloy96623832cloy
cloze165517542cloze
clue65324532clue
cole66956112cole
dale55643982dal_e
doe47361952_doe
dole56550002dole
elope75219342elope
else45923082else
false84818122false
flee76238792flee
floc95922122floc
floes85528142floes
flog85523892flog
flop96925452flop
flow105924922flow
flue75329852flue
foe66350812_foe
froe75329992froe
gale56347322gal_e
galop84716222galop
galore73514872galore
glee55239062glee
glob76623392glob
globe84917012globe
glom75424382glom
glop76724632glop
glove94516292glove
glow85222522glow
gloze154815982gloze
glue55628492glue
hale76052832hal_e
halo76437322halo_
haloed104717602haloed
haloes94623862haloes
halon86124862halon
halos85230252halos
halve114818922halve
haole84820082haole
hoe67562722_hoe
hole77553392hole
jalop144212602jalop
joe106642352_joe
jole117233822jole
kale86533752kal_e
lace66848472lace
lade56345982lade
lake85741602lake
lame66849292lame
lane45153332lane
lase46148512lase
late47560482late
lave75642142lave
laze136235052laze
lee36068142_lee
lie38264522_lie
lo28053442_lo_
lob57154462_lob
lobe65535362_lobe
lode56240112_lode
log46252682_log
loge56837192_loge
lone45849132_lone
loo38359822_loo
lop58255312_lop
lope65941922_lope
lore45850352_lore
lose45144582_lose
lot38179262_lot
love75234762_love
low66051872_low
lowe75435312_lowe
lox108240962_lox
lye66533412_lye
mahoe10315572mahoe
male66052302mal_e
mole66251832mole
oboe66822942oboe
oe28473062__oe
ole37155212ol_e
oleo46630482oleo
pale66055012pal_e
plie65127392plie
plod76723272plod
plop86625742plop
plot66141232plot
plow95923232plow
ploy96123602ploy
pole65951302pole
rale45050562ral_e
roe36861082_roe
role45851822role
sale44959702sal_e
salol55222142salol
salon55228552salon
salve85022132salve
shoe75933442shoe
slob66029422slob
sloes54728872sloes
slog56728272slog
slop66533872slop
slope75823562slope
slot46049832slot
slow77729492slow
slue45332192slue
sole46053672sole
tale46154162tal_e
talon55824112talon
toe310166852_toe
tole46052902tole
vale74937342val_e
valor83614892valor
valse85117522valse
value85719092value
valve114515932valve
voe67739052_voe
vole75236982vole
wale74546432wal_e
woe66651242_woe
zlote143912942zlote

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.300595636.7
2DLD Change Limit298722840.96630923.4
3Display Results2842840.0634507.9
 (SQL Overall)1786912841.329134455.2
 
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.