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

108 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
along6541949(None) 
alang66023511alang
alone55732961alone
among85813301among
flong95815681flong
kalong1177701kalong
klong105310401klong
long56933341_long
acing87429152acing
aeon45634612aeon_
aeons57624652aeons
agelong934982agelong
aging77026352aging
agog68019002ago_g
agon56531882agon_
agone65924552agone
agons66423782agons
agony96415652agony
ahing98928352ahing
ailing74331012ailing
alan46844082alan_
aland65526412aland
alane56135612alane
alans55636172alans
alant55742292alant
align65016502align
aline57243152aline
allonge837022allonge
almond91410432almond
almug8429302almug
aloe45540192alo_e
aloes54933672aloes
aloft8423432aloft
aloha8513622aloha
aloin55227422aloin
aloins65022202aloins
aloof83521572aloof
aloud65018072aloud
alow75328592alo_w
anon46134852anon_
aping87327232aping
atone56527982atone
atony87218852atony
awing96827322awing
axing138521372axing
axon115524302axon_
axone125918472axone
axons125517932axons
azlon144312872azlon_
azlons154110422azlons
azon135725052azon_
azons146518252azons
baling94829692baling
barong96015822barong
belong93411042belong
blog75723822blo_g
blond85618372blond
bong75633412_bong
clang86019312clang
cling86424672cling
clog76123242clo_g
clon66232482clon_
clone75728162clone
clonk114417442clonk
clons75228132clons
clung86013602clung
daylong1233972daylong
dong66031652_dong
fling97023512fling
flog85523892flo_g
flongs105010492flongs
flung95114582flung
glogg837352glogg
gong66827192_gong
haling104229782haling
haloing113814132haloing
halon86124862halon_
halons95720712halons
hong85833952_hong
kalongs1255442kalongs
klongs11436602klongs
lang56637392_lang
ling57447972_ling
log46252682_lo_g
lone45849132_lone
longe66626462_longe
longs65527062_longs
lung55732492_lung
oblong935382oblong
oolong738072oolong
paling93530132paling
plonk114613982plonk
pong76231142_pong
prong85218112prong
salon55228552salon_
salons63823692salons
sarong73914872sarong
slang66324022slang
sling66028802sling
slog56728272slo_g
slung65117832slung
song55133672_song
talon55824112talon_
talons64019442talons
thong95014182thong
tong56434362_tong
waling104525302waling
wrong94712322wrong

Search took 8 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 Filter178691538001.033172982.6
2DLD Change Limit538001085.6869461.8
3Display Results1081080.0303600.0
 (SQL Overall)1786911086.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.