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

491 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
aglare731242(None) 
glare65222951_glare
ablate82219212ablate
ablaze17239832ablaze
aflame1138722aflame
agape85614842ag_ape
agar58726412ag_ar_
agars66120642ag_ars
agate66525152ag_ate
agave95314032ag_ave
agaze156113662ag_aze
aglee65728492agl_ee
agnate73314882agnate
agorae7511202agorae
agrafe1038092agrafe
alae45643752a_la_e
alane56135612a_lane
alar46340072a_lar_
alarm76621422a_larm
alary86123442a_lary
alate55340322a_late
algae65319622alga_e
allure63012942allure
anlace82513922anlace
anlage72514232anlage
aware86420022a_ware
blare75826232_blare
flare84823632_flare
galere73716672galere
galore73514852galore
glace87420152_glace
glade75121962_glade
glaire74411292_glaire
glared84715192_glared
glares75518862_glares
glary96018542_glary
glaze155418162_glaze
abase76023483a_base
abate76627843a_bate
abjure1536743abjure
ablated102513443ablated
ablates92416903ablates
ablaut8313263ablaut
able66340533abl__e
abler75624313abler_
aboard9312613aboard
abrade9313053abrade
acari75020283a_cari
acre67330773a__cre
acuate8315633acuate
acylate12310533acylate
adage7414053a_dage
adhere10310333adhere
adjure1435843adjure
admire949933admire
adnate72913483adnate
adore65723673a_dore
adulate8313233adulate
aerate64830553aerate
afar76720783a_far_
afars85716513a_fars
afeard1058263afeard
afeared1176833afeared
affaire1344463affaire
afire86215913a_fire
afore85818603a_fore
aga410447233ag_a__
again65218123ag_ain
agama85815583ag_ama
agapae9388043agapae
agapes95212413ag_apes
agaric93513633ag_aric
agarose838673ag_arose
agas55938843ag_a_s
agates76121343ag_ates
agaves104611513ag_aves
age47154333ag___e
agee56241493ag__ee
agemate101210583agemate
agene65621583ag_ene
ager55935843ag_er_
agers65027853ag_ers
aggada955223aggada
agger76420893agger_
aggers85817793aggers
aggie73415013ag_gie
aggrade1035643aggrade
aggro738013ag_gro
agha87417303agha__
aghas97014873agha_s
aghast105711373aghast
agile65122263ag_ile
agitate8312063agitate
agleam9158623agleam
aglet65534143agl_et
aglets73915683aglets
agley96917333agl_ey
aglow94711973agl_ow
agly86821803agl__y
agma77623263agma__
agmas85919873agma_s
agnail739533agnail
agnates82813193agnates
agnize16329563agnize
agone65924553ag_one
agora6914333ag_ora
agoras7613343agoras
agrafes1137523agrafes
agraffe1443333agraffe
agree65226033ag_ree
ague55725923ag__ue
airfare1047243airfare
ajar116217703a_jar_
ala312463603a_la__
alack114820063a_lack
alamo7418143a_lamo
alan46844083a_la_n
aland65526413a_land
alang66023513a_lang
alans55636173a_lans
alant55742293a_lant
alarmed1037733a_larmed
alarms85913053a_larms
alarum85411983a_larum
alas46358123a_la_s
alated75625143a_lated
alates64833963a_lates
alcade91111513alcade
alder65421913a_lder
ale36572343a_l__e
alee46652323a_l_ee
alert54740653a_lert
alga57927603alga__
algal66518223alga_l
algas65624933alga_s
algor6513053algor_
algors7312553algors
alike95523963a_like
aline57243153a_line
alive85722513a_live
alkane104313323alkane
alkie95520033a_lkie
allay85620393alla_y
allayed11138063allayed
allayer10148213allayer
allays94313743allays
allee54932123a_llee
allege74314653allege
allele64514563allele
allude73910903allude
allured8299173allured
allurer7348433allurer
allures72913113allures
alme65832163a_l_me
aloe45540193a_l_oe
alone55732963a_lone
altar55520643altar_
altars64518153altars
alter54828503a_lter
alulae6312743alula_e
alular6311353alular_
amaze166016603a_maze
ambage11510603ambage
ambari103012173ambari
ambary134010543ambary
ampere10514413ampere
amylase1237023amylase
anear55420323anear_
aneared8512743aneared
anears63717183anears
angary10311323angary
angle64528873angl__e
angler74017863angler_
anglers84014823anglers
anglice1089213anglice
angular838533angular_
angulate9312013angulate
anlaces92313733anlaces
anlagen8238643anlagen
anlages82414113anlages
anlas55626933anla_s
anlases72514903anlases
ansae55720973ansa_e
ansate64517863ansate
antae56828293anta_e
antiglare1046343antiglare
antre55224523a_ntre
apace94718383a_pace
apart74330673a_part
apiary113910383apiary
aplite8316393aplite
apparel1146003apparel
aquae142212713aqua_e
arame75026623a_rame
arcade91013643arcade
arcane81216743arcane
are37874573___are
areae55229743area_e
argle65421563argl__e
ariary94114203ariary
armure8710133armure
ascared10399523ascared
ashlar9338193ashlar_
ashlared1253933ashlared
ashlars10297063ashlars
ashore9414613ashore
aslant6317753aslant
aslope839013aslope
aspire8612123aspire
assure6610773assure
aswarm11107913aswarm
atlas55821583atla_s
atlases72410643atlases
atlatl637873atlatl
attar56516693attar_
attars64515313attars
attire62412383attire
aubade939223aubade
aulder7511453aulder
aurae54128113aura_e
aurar54420253aurar_
aurate64426473aurate
aviary12338413aviary
aviate9315203aviate
awake125014783a_wake
award97118043a_ward
aweary1237303aweary
axle116424603axl__e
axlike17388853axlike
azure14911483a_zure
baggage1235633baggage
baglike14338943baglike
ballade104012563ballade
bare65460523__bare
barware12610703barware
beware11313713beware
blade85923333_blade
blae66134643_bla_e
blame95625493_blame
blared95018243_blared
blares85021633_blares
blase75524233_blase
blate75933783_blate
blaze165520833_blaze
bolar75123473bolar_
care66968373__care
carfare12310073carfare
caviare1238373caviare
chare105231983_chare
clade85821013_clade
claret84026573_claret
claro75018693_claro
clary105719613_clary
clave105420153_clave
colure8314163colure
curare84916953curare
dare55848863__dare
daycare1355093daycare
daymare1375633daymare
decare93919153decare
declare10411223declare
deglaze1835583deglaze
dekare112811563dekare
delate73827753delate
dilate73220693dilate
eagle64219483eagl__e
eagre64315323eag__re
eggar7458883eggar_
eggars8398973eggars
eglatere945153eglatere
elate55335883_elate
enlace82213233enlace
enlarge835533enlarge
failure1035753failure
fanfare1336673fanfare
fare76354463__fare
filar84819293filar_
filaree10611213filaree
flake125119973_flake
flame105124443_flame
flared105317603_flared
flares94521703_flares
folate93320393folate
gae46457703_g_a_e
gage65936103_g_age
gala55635163gala__
galago838903galago
galah95917633gala_h
galahs105512673galahs
galas65731643gala_s
galatea839953galatea
galax135314463gala_x
galaxes1538873galaxes
galaxy17476313galaxy
gale56347323_g_ale
galeae74717453galeae
galeate83916783galeate
galeres83514333galeres
gallate83417123gallate
galores82614323galores
game76644323_g_ame
gane55145303_g_ane
gape75134513_g_ape
gar47259903_g_ar_
garage8314513garage
garb75332673_g_arb
gars55750743_g_ars
gate55746573_g_ate
gavage1137193gavage
gave84634053_g_ave
gazar154612983gazar_
gazars164811553gazars
gaze145032413_g_aze
gear55934973_gear_
geared85317743_geared
gears64628693_gears
gelate73421253gelate
genre66016803_genre
glaces94218023_glaces
glad65624013_gla_d
glades84820343_glades
glads75620613_glads
glady105413943_glady
glair65313553_glair
glaired9387743_glaired
glaires84010133_glaires
glairs75211333_glairs
glairy10448273_glairy
glaive10357933_glaive
glam76529343_gla_m
glams85822933_glams
glance94312313_glance
gland75217713_gland
glans65125833_glans
glarier84112203_glarier
glass65518133_glass
glazed174711773_glazed
glazer164212263_glazer
glazes165315643_glazes
glazy187410983_glazy
glebe85016443_glebe
glede75517833_glede
glee55239063_gl_ee
glide74521593_glide
glime85620193_glime
globe84917013_globe
glory96413293_glory
glove94516293_glove
gloze154815983_gloze
glue55628493_gl_ue
gluer65116773_gluer
glume85120463_glume
glute66020903_glute
gnar56021383_gnar_
gnarl65115573_gnarl
gnarr64810693_gnarr
gnars66718853_gnars
gore55744963_g_ore
grace85124543_grace
grade75126093_grade
grape84824663_grape
grate64932883_grate
grave94624873_grave
graze155820053_graze
guar56923293_guar_
guard74415543_guard
guars65021053_guars
gular6314833gular_
gyre84722763_g_yre
haggard13377183haggard
hare76255733__hare
haulage1136913haulage
haylage1436443haylage
hilar85418143hilar_
holard10410573holard
ignore7269063ignore
infare9313083infare
inlace82513043inlace
jaggary19304863jaggary
jaguar1435283jaguar_
jaguars1535233jaguars
lace66848473__lace
lade56345983__lade
laggard10347623laggard
lake85741603__lake
lame66849293__lame
lane45153333__lane
lar37967533__lar_
lard56742003__lard
laree56036293__laree
lares54852633__lares
large65325463__large
lari45839153__lari
lark85733863__lark
lars46956573__lars
lase46148513__lase
late47560483__late
lave75642143__lave
laze136235053__laze
lire47845293__lire
lore45850353__lore
lure45142463__lure
lyre75623793__lyre
magnate10512703magnate
malar76424443malar_
malars85020683malars
malate84624553malate
malgre9299303malgre
mallard10310273mallard
mare64759333__mare
milage93414123milage
molar75223093molar_
molars85517323molars
mylar105311533mylar_
mylars114310443mylars
nonglare946373nonglare
oblate82214743oblate
ogle56325053ogl__e
ogler65917443ogler_
oglers74313183oglers
ogre56320743og__re
outglare937383outglare
palace104516913palace
palate84226783palate
pare66760843__pare
pelage9515363pelage
pilar75221503pilar_
place94824613_place
plage84520403_plage
plane74929143_plane
plate74635113_plate
polar75623453polar_
polars84419353polars
quare143920543_quare
raglan73711503ragla_n
raglans82410133raglans
rare45348433__rare
reglaze1747223reglaze
relace83122153relace
relate64033633relate
saggar84010853saggar_
saggard10358953saggard
saggared11326063saggared
saggars93610683saggars
saguaro845513saguaro
salary9515213salary
scalare93311833scalare
scare75334463_scare
share86437083_share
silage72715303silage
silane62718053silane
slake93724053_slake
slate55438283_slate
slave84224033_slave
snare54429983_snare
solace83415823solace
solar55927343solar_
solate64526073solate
spare75135563_spare
splake1259783splake
splore81611303splore
square154513363square
stare54440263_stare
sware85828213_sware
taglike12278913taglike
tagline82412453tagline
talar56225383talar_
talars66021683talars
tallage82712073tallage
tare45957623__tare
tartare73012683tartare
telae54323293tela_e
tolane64316583tolane
tolar55524113tolar_
tolars64817943tolars
uglier748953uglier
ullage739043ullage
unlace82215173unlace
unlade72714153unlade
urare56322553_urare
vagary1337333vag_ary
vallate103016563vallate
velar85817633velar_
velars93913723velars
velate93720143velate
velure939773velure
volar86917413volar_
ware76254723__ware
warfare1336733warfare
welfare1335713welfare
yare75636943__yare

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.406440125.6
2DLD Change Limit1127164915.06322262.7
3Display Results4914910.1533209.2
 (SQL Overall)1786914915.62231784.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.