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

289 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
agleam915862(None) 
gleam86916731_gleam
abeam9316532a_beam
aglee65728492agle_e
aglet65534142agle_t
aglets73915682aglets
agley96917332agle_y
fleam106017282_fleam
galea64722932galea_
galeae74717452galeae
galeas74618502galeas
glam76529342_gl_am
gleams94812252_gleams
gleamy12398112_gleamy
glean65818202_glean
gloam86015942_gloam
able66340533able__
abled86926833able_d
ableism1136823ableism
abler75624313able_r
ables75935543able_s
ablest84721833ablest
abloom1039783abloom
adeem8311803a_deem
aflame1138723afl_ame
afloat9315153afloat
aga410447233ag__a_
agama85815573ag__ama
agamas97413443agamas
agapae9388043agapae
agapai9456843agapai
agar58726413ag__ar
agas55938843ag__as
age47154333ag_e__
aged67334253ag_e_d
agee56241493ag_e_e
ageism968803ageism
ageless8310343ageless
agene65621583ag_ene
agent65829643ag_ent
ager55935843ag_e_r
agers65027853ag_ers
ages55844593ag_e_s
agger76420893agge_r
aggers85817793aggers
agha87417303ag_ha_
aghas97014873ag_has
agile65122263agile__
agilely1135123agilely
agism84614063ag_ism
agita6315423agita_
agitas7310593agitas
aglare7312423aglare
aglow94711963agl_ow
agly86821803agl__y
agma77623263ag_ma_
agmas85919873ag_mas
agonal7410053agonal
agora6914333agora_
agorae7511203agorae
agoras7613343agoras
agree65226033agre_e
agreed84712503agreed
agrees74915323agrees
agria65517143agria_
agrias74315393agrias
ague55725923ague__
agues64919053ague_s
ahead96817053a_head
ahem97225363a_he_m
aiglet74224193aigle_t
aiglets84012913aiglets
ailed66240283aile_d
akela9311343akela_
akelas10311193akelas
ala312463603a_l_a_
alae45643753a_l_ae
alamo7418143a_l_amo
alan46844083a_l_an
alar46340073a_l_ar
alarm76621423a_larm
alas46358123a_l_as
alba68328333a_lba_
albas75925393a_lbas
album92312653a_lbum
ale36572343a_le__
alec66430063a_le_c
alecs76620733a_lecs
alee46652323a_le_e
alef76340693a_le_f
alefs87319663a_lefs
alegar739283a_legar
aleph10311393a_leph
alert54740653a_lert
ales47067103a_le_s
alfa77624273a_lfa_
alfas87219043a_lfas
alga57927603a_lga_
algae65319623a_lgae
algal66518213a_lgal
algas65624933a_lgas
algum82711763a_lgum
alias55834603a_lias
allay85620393a_llay
allee54932123alle_e
allees64521483allees
allege74314643allege
allele64514563allele
alley85721673alle_y
alleys95113303alleys
allheal1044553allheal
allium8311243allium
alma66333023a_lma_
almah106917253a_lmah
almas76629773a_lmas
altar55520643a_ltar
alum65227613a_l_um
alway116113923a_lway
amalgam1244913amalgam
anear55420323a_near
angle64528873angle__
angled84219073angle_d
angler74017863angle_r
anglers84014823anglers
angles74426703angle_s
anlas55626933anl_as
anneal64812293anneal
apeak115513453a_peak
apnea73413413apnea_
apneal83411123apneal
apneas83211383apneas
appeal103911613appeal
appear10379343appear
area45843393a_rea_
areae55229743a_reae
areal55928733a_real
areas55935773a_reas
argle65421563argle__
argled85314543argle_d
argles75218483argle_s
arles56735743arle_s
arrear6310253arrear
asea46327183a_sea_
ashram1139053ashram
asleep847283asleep
atlas55821583atl_as
awless939263awless
axle116424603axle__
axled135315813axle_d
axles125219473axle_s
azalea1537003azalea_
azaleas1636993azaleas
balsam105612233balsam
beam86939233__beam
beldam11410113beldam
beleap10410283beleap
blam86131703_bl_am
bleak115915383_bleak
blear75918683_blear
bleat75737003_bleat
bream95121813_bream
clam86332293_cl_am
clean75420413_clean
clear76219053_clear
cleat76335063_cleat
colead94114643colead
cream95721343_cream
delead84112343delead
dream85120393_dream
eagle64219483eagle__
eagled82914043eagle_d
eagles73819163eagle_s
eaglet73722583eagle_t
eaglets84111663eaglets
flam96333293_fl_am
flea75628493_flea_
fleams115011943_fleams
fleas86423663_fleas
fulham1435303fulham
fullam1138363fullam
gala55635163gal_a_
galah95917623gal_ah
galas65731643gal_as
galax135314463gal_ax
gale56347323gale__
galeate83916783galeate
galena74911093galena
galenas83310333galenas
galere73716673galere
gales65442483gale_s
galyac1235973galyac
galyak1445333galyak
gam67060063_g__am
gateau778103gateau
gear55934973_g_ear
gem66840223_g_e_m
germ75428963_g_erm
geum75424553_g_eum
glad65624013_gl_ad
glams85822933_gl_ams
gleamed11327933_gleamed
gleamer10328513_gleamer
gleans75014743_gleans
gleba83910243_gleba
glebae9407613_glebae
glebe85016443_glebe
gled65631143_gle_d
glede75517833_glede
gleds75417893_gleds
glee55239063_gle_e
gleed75320573_gleed
gleek105315103_gleek
glees65027593_glees
gleet65532343_gleet
gleg66219803_gle_g
glen56027203_gle_n
glens66519853_glens
gley85724653_gle_y
gleys96514853_gleys
glia56423153_glia_
glial66715433_glial
glias64618493_glias
glim76026353_gl_im
gloams95210663_gloams
gloat65427683_gloat
glom75424383_gl_om
gloom87116523_gloom
glum75825103_gl_um
golem8416113gole_m
gram77034583_g_ram
great66034243_great
ilea45931463_ilea_
ileac75814173_ileac
ileal56118083_ileal
ileum74512823_ileum
inseam8329993inseam
jagless1537103jagless
kalam11315113kal_am
lam57666713__l_am
lea37660183__lea_
lead56038853__lead
leaf76441033__leaf
leak86233713__leak
leal46043273__leal
lean46345243__lean
leap66032683__leap
lear47045953__lear
leas45954183__leas
loam65630483__loam
maglev1237023magle_v
maglevs1334693maglevs
ogam75120033og__am
ogham1138253og_ham
ogle56325053ogle__
ogled75915963ogle_d
ogler65917443ogle_r
oglers74313183oglers
ogles65223183ogle_s
olea46532723_olea_
oleum73613323_oleum
outgleam1153633outgleam
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
phlegm1433093phlegm
pilea75123953pilea_
pileum10399513pileum
plea66830603_plea_
plead85818463_plead
pleas75627033_pleas
pleat74734473_pleat
poleax1547993poleax
raglan73711503ragl_an
ream65841613__ream
reteam83214533reteam
salaam8711013salaam
scream104814243scream
seam66645973__seam
slam67737973_sl_am
steam76322923_steam
stream84717283stream
tableau966273tableau
team66238653__team
ulema7109713_ulema
unlead73312373unlead
unseam83313143unseam
upleap10106843upleap
xylem1736123xyle_m
ylem9217893_yle_m

Search took 7 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.1431249587.4
2DLD Change Limit1127162895.95018943.9
3Display Results2892890.0803612.5
 (SQL Overall)1786912896.17328947.2
 
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.