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

321 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
alae4564375(None) 
ala312463601ala_
alan46844081alan
alane56135611alane
alar46340071alar
alas46358121alas
alate55340321alate
ale36572341al_e
alee46652321alee
algae65319621algae
alme65832161alme
aloe45540191aloe
blae66134641blae
aa219179952a_a_
aah616252962a_ah
aal39058672a_al
aals49941142aals
aas310975392a_as
aba512850952aba_
abas68642082abas
abase76023482abase
abate76627842abate
abbe87627192abbe
ablate82219212ablate
ablaze17239832ablaze
able66340532able
abye97921002abye
ace59656832a_ce
ache96829822ache
acme86924322acme
acne66625872acne
acre67330772acre
adage7414052adage
adze1412820572adze
ae212590292__ae
afar76720782afar
aflame1138722aflame
aga410447232aga_
agape85614842agape
agar58726412agar
agas55938842agas
agate66525152agate
agave95314032agave
agaze156113662agaze
age47154332a_ge
agee56241492agee
aglare7312422aglare
aglee65728492aglee
ague55725922ague
aha611246642aha_
aide56045002aide
ajar116217702ajar
ajee115928232ajee
akee85936812akee
al210674042al__
alack114820062alack
alamo7418142alamo
aland65526412aland
alang66023512alang
alans55636172alans
alant55742292alant
alarm76621422alarm
alary86123442alary
alated75625142alated
alates64833962alates
alb57342652al_b
alba68328332alba
albas75925392albas
albs68628572albs
alcade91111512alcade
alder65421912alder
alec66430062alec
alef76340692alef
ales47067102ales
alfa77624272alfa
alfas87219042alfas
alga57927602alga
algal66518222algal
algas65624932algas
alias55834602alias
alien56425582alien
alif76242142alif
alike95523962alike
aline57243152aline
alit46155692alit
alive85722512alive
alkane104313322alkane
alkie95520032alkie
alky115920342alky
all36148232al_l
allay85620392allay
allee54932122allee
alley85721672alley
alls46740922alls
ally76935642ally
alma66333022alma
almah106917252almah
almas76629772almas
almeh106214552almeh
almes75126542almes
alms65834922alms
aloes54933672aloes
alone55732962alone
alow75328592alow
alp56641132al_p
alps65529242alps
als36663022al_s
also46423442also
alt36467962al_t
altar55520642altar
alter54828502alter
alto47831262alto
alts46639902alts
alulae6312742alulae
alum65227612alum
alway116113922alway
ama510853302ama_
amah98927492amah
amas67746292amas
amaze166016602amaze
amie66339852amie
ana39559832ana_
anal48037522anal
anas46649862anas
ane37866952a_ne
anlace82513922anlace
anlage72514232anlage
anlas55626932anlas
ansae55720972ansae
antae56828292antae
ante46538902ante
apace94718382apace
ape57251182a_pe
apse67725382apse
aquae142212712aquae
arak86929572arak
arame75026622arame
are37874572a_re
area45843392area
areae55229742areae
arse46539272arse
asea46327182asea
atap66722452atap
ate37059242a_te
atlas55821582atlas
aurae54128112aurae
ava610139322ava_
ave67748702a_ve
awa611939672awa_
awake125014782awake
aware86420022aware
away108024222away
awe67746622a_we
awee76336642awee
axal116520492axal
axe108239492a_xe
axle116424602axle
ayah108022992ayah
aye67151762a_ye
azan136521782azan
balas76937212balas
bale66353842bal_e
blab86629132blab
blade85923332blade
blah98625062blah
blam86131702blam
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat
blate75933782blate
blaw97026722blaw
blaze165520832blaze
blue65328462blue
brae65639112brae
calve105919922calve
clad76225822clad
clade85821012clade
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
clave105420152clave
claw95624342claw
clay95927412clay
clue65324532clue
dale55643982dal_e
elan46734242elan
elate55335882elate
else45923082else
false84818122false
flab96628352flab
flag87427082flag
flak116026172flak
flake125119972flake
flam96333292flam
flame105124442flame
flan76134182flan
flap96128702flap
flare84823632flare
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
flea75628492flea
flee76238792flee
floe76129772floe
flue75329852flue
frae75330472frae
gae46457702_gae
gala55635162gala_
galah95917632galah
galas65731642galas
galax135314462galax
gale56347322gal_e
galea64722932galea
galeae74717452galeae
glace87420152glace
glad65624012glad
glade75121962glade
glam76529342glam
glare65222952glare
glaze155418162glaze
glee55239062glee
glue55628492glue
hae67364002_hae
halal85623592halal
hale76052832hal_e
halve114818922halve
ilea45931462ilea
jalap143612472jalap
kae76744542_kae
kalam11315112kalam
kale86533752kal_e
la219261632_la_
lab58864782_lab
lac510155822_lac
lace66848472lace
lad48165702_lad
lade56345982lade
lag47862122_lag
lake85741602lake
lam57666712_lam
lame66849292lame
lane45153332lane
lap58565272_lap
lar37967532_lar
las37281472_las
lase46148512lase
lat37593402_lat
late47560482late
lav66847342_lav
lave75642142lave
law68656642_law
lax107651522_lax
lay68865352_lay
laze136235052laze
lea37660182_lea
lee36068142_lee
lie38264522_lie
lye66533412_lye
mae57659112_mae
malar76424442malar
malate84624552malate
male66052302mal_e
nae35952742_nae
nala46930392nala_
nalas55528362nalas
ole37155212ol_e
olea46532722olea
palace104516912palace
palate84226782palate
pale66055012pal_e
palea75028662palea
paleae84820292paleae
parae76335702parae
place94824612place
plage84520402plage
plan65833942plan
plane74929142plane
plat66048872plat
plate74635112plate
play95928982play
plea66830602plea
plie65127392plie
rale45050562ral_e
sae38365182_sae
salad65321832salad
salal55425702salal
sale44959702sal_e
salpae84614272salpae
salve85022132salve
slab67133762slab
slag55934352slag
slake93724052slake
slam67737972slam
slap66434042slap
slat46959022slat
slate55438282slate
slave84224032slave
slaw77930712slaw
slay76436382slay
sloe45534952sloe
slue45332192slue
spae65034322spae
tae38267052_tae
tala45938052tala_
talar56225382talar
talas55935892talas
tale46154162tal_e
telae54323292telae
thae76825562thae
twae74719572twae
ulan46527392ulan
ulnae55214572ulnae
vale74937342val_e
valse85117522valse
value85719092value
valve114515932valve
wae67556952_wae
wale74546432wal_e

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.280638182.1
2DLD Change Limit298723210.95331345.2
3Display Results3213210.0764223.7
 (SQL Overall)1786913211.309136509.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.