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

170 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
alone5573296(None) 
agone65924551agone
alane56135611alane
aline57243151aline
aloe45540191alo_e
along65419491along
atone56527981atone
axone125918471axone
clone75728161clone
lone45849131_lone
abalone938902abalone
abode85518812abode
above105414322above
acne66625872a_cne
adobe84814712adobe
adore65723672adore
adoze155713832adoze
aeon45634612aeon_
aeons57624652aeons
afore85818602afore
agene65621582agene
agon56531882agon_
agones75719862agones
agons66423782agons
agony96415652agony
akene95818662akene
alae45643752al_ae
alan46844082alan_
aland65526412aland
alang66023512alang
alans55636172alans
alant55742292alant
alate55340322alate
alcove1178082alcove
aldose7311092aldose
ale36572342al__e
alee46652322al_ee
algae65319622algae
alien56425582alien
alike95523962alike
alined75221402alined
aliner65621982aliner
alines65735222alines
alive85722512alive
alkane104313322alkane
alkene104114002alkene
alkie95520032alkie
alkine104916802alkine
alkyne13436862alkyne
allee54932122allee
allonge837022allonge
alme65832162al_me
almner85710722almner
almond91410432almond
almoner949382almoner
aloes54933672aloes
aloft8423432aloft
aloha8513612aloha
aloin55227422aloin
aloins65022202aloins
aloof83521572aloof
aloud65018072aloud
alow75328592alo_w
alpine84417372alpine
alvine94614582alvine
amine75835382amine
amole75724592amole
among85813302among
ancone83916952ancone
ane37866952a__ne
anode65021042anode
anole55330382anole
anon46134852anon_
anyone94612732anyone
arene55329412arene
arose55832082arose
aslope839012aslope
atoned75417542atoned
atoner64817192atoner
atones65225772atones
atony87218852atony
awoke124912002awoke
axon115524302axon_
axones134614512axones
axons125517932axons
azine146721412azine
azlon144312872azlon_
azlons154110422azlons
azole145118032azole
azon135725052azon_
azons146518252azons
azote144416342azote
baloney1237482baloney
bloke114316632bloke
blond85618372blond
blonde94813292blonde
bone65949322_bone
calzone1848622calzone
chalone12312102chalone
cline76428532cline
clon66232482clon_
cloned94518802cloned
cloner84418092cloner
clones84526562clones
clonk114417442clonk
clons75228132clons
close76425222close
clove105619442clove
cloze165517542cloze
colone85425002colone
cone67256962_cone
crone75231332crone
done55747912_done
drone65324982drone
elope75219342elope
floe76129772flo_e
flong95815682flong
galore73514852galore
globe84917012globe
glove94516292glove
gloze154815982gloze
gone55639042_gone
halon86124862halon_
halons95720712halons
hone77549322_hone
irone55126362irone
kalong1177702kalong
klong105310402klong
krone94018732krone
lane45153332_lane
leone55018822leone
line46965572_line
lobe65535362_lobe
lode56240112_lode
loge56837192_loge
loner55431042_loner
long56933342_long
longe66626462_longe
lope65941922_lope
lore45850352_lore
lose45144582_lose
love75234762_love
lowe75435312_lowe
lune47140492_lune
maline84529082maline
none45743172_none
one37050912__one
ozone14310612ozone
phone105621932phone
plane74929142plane
plonk114613982plonk
pone65747532_pone
prone75332622prone
saline65132702saline
salon55228552salon_
salons63823692salons
scone74621832scone
shone83725982shone
sloe45534952slo_e
slope75823562slope
sone46649982_sone
stone55431182stone
talon55824112talon_
taloned8310222taloned
talons64019442talons
tone46953742_tone
trone55131862trone
valine94623092valine
zlote143912942zlote
zone135231082_zone

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001701.75330690.2
3Display Results1701700.0433953.5
 (SQL Overall)1786911702.10684848.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.