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

255 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
aline5724315(None) 
alane56135611alane
alien56425581alien
alike95523961alike
alined75221401alined
aliner65621981aliner
alines65735221alines
alive85722511alive
alkine104916801alkine
alone55732961alone
alpine84417371alpine
alvine94614581alvine
amine75835371amine
azine146721411azine
cline76428531cline
line46965571_line
maline84529081maline
saline65132701saline
valine94623091valine
abide86223702abide
ablins8316192ablins
acing87429152acing
acini75718982acini
acne66625872a_cne
aedine73218392aedine
affine12310502affine
afire86215912afire
agene65621582agene
agile65122262agile
agin56132712agin_
aging77026352aging
agone65924552agone
ahing98928342ahing
aide56044992a_ide
ailing74331012ailing
ain37579092a_in_
ains46158882a_ins
airline7315032airline
akene95818662akene
akin86328032akin_
alae45643752al_ae
alan46844082alan_
aland65526412aland
alang66023512alang
alanine7316862alanine
alans55636172alans
alant55742292alant
alate55340322alate
albino839922albino
albite8313302albite
ale36572342al__e
alee46652322al_ee
alexine142410542alexine
algae65319622algae
algin65718762algin_
algins74816432algins
alias55834602alias
alibi7514222alibi
alible8311972alible
aliened81011742aliened
alienee71013152alienee
aliener71011192aliener
aliens65619212aliens
alif76242132ali_f
alifs86121262alifs
align65016502align
aligned9128552aligned
aligner8108302aligner
aligns75312952aligns
aliners74717722aliners
aliped95414282aliped
alist56136782alist
alit46155692ali_t
aliunde835002aliunde
aliya83713482aliya
alkane104313322alkane
alkene104114002alkene
alkie95520032alkie
alkines114415732alkines
alkyne13436862alkyne
allee54932122allee
alme65832162al_me
almner85710722almner
aloe45540192al_oe
aloin55227412aloin_
aloins65022202aloins
along65419492along
alpines94016192alpines
alsike1047912alsike
alumine9412692alumine
amice96122862amice
amide86128472amide
amie66339842ami_e
amin66042242amin_
amines84727982amines
amino75425492amino
amins75534312amins
ammine10314482ammine
ane37866942a__ne
anile54634462anile
aniline7418472aniline
anime75423202anime
anise55129702anise
aping87327232aping
aplite8316392aplite
arene55329412arene
arise56436432arise
arsine64021042arsine
aside65122082aside
atone56527982atone
awing96827322awing
axile126020512axile
axing138521372axing
axite125218252axite
axlike17388852axlike
axone125918472axone
ayin76331742ayin_
ayins85321612ayins
azide155617162azide
azines155517072azines
baling94829692baling
bine66650852_bine
blin67228172blin_
blind86319322blind
blini75519272blini
blink115720142blink
blite76225352blite
brine75132272brine
byline11311642byline
calcine11315272calcine
canine83826702canine
carline93923612carline
cauline92215602cauline
chine105231722chine
cine66242942_cine
clime95720892clime
clines84926042clines
cling86424672cling
clink115320042clink
clone75728162clone
dine55555332_dine
dwine95616142dwine
elide64922642elide
elint55436472elint
elite56230182elite
exine125518492exine
famine114318192famine
feline94820142feline
fine75147952_fine
fling97023512fling
flint87333502flint
flite85424962flite
gamine94620152gamine
glide74521592glide
glime85620192glime
glint66830182glint
gwine95513662gwine
halide103417992halide
haling104229782haling
halite93624232halite
hyaline132310722hyaline
imine75821042imine
jawline17137062jawline
kaoline11310142kaoline
kine85643422_kine
koine9516482koine
lain46146282lain_
lane45153322_lane
larine63927042larine
lawine93316462lawine
liane54720662_liane
lice66045062_lice
lie38264522_li_e
lien45339802_lien
life75433732_life
like86040842_like
lime66244932_lime
lin37967372_lin_
lined64934642_lined
linen55728722_linen
liner55938912_liner
lines57054572_lines
liney87029622_liney
ling57447962_ling
link86943442_link
linn46034592_linn
lino46343372_lino
lins47059052_lins
lint416266232_lint
liny78141322_liny
lipe66839732_lipe
lire47845292_lire
lite47054542_lite
live76540992_live
lone45849132_lone
lune47140492_lune
malice104818482malice
malines93625602malines
marine84230402marine
marline93320952marline
mine67256152_mine
moline84422032moline
narine63422552narine
nine45842172_nine
oleine6313792oleine
olive84817152olive
online6315842online
opaline9412482opaline
opine77422462opine
ovine86316642ovine
paling93530132paling
patine85328122patine
pine67755712_pine
plane74929142plane
plie65127392pli_e
plink115219122plink
praline93019742praline
ralline73518412ralline
rapine85023082rapine
ratine65131822ratine
ratline74517802ratline
ravine95522222ravine
reline65434352reline
sabine84020382sabine
salina64221122salina
salines74029412salines
saltine75018562saltine
savine94220282savine
seine55732872seine
shine85533092shine
sine46560622_sine
slice74925822slice
slide64725412slide
slime74925752slime
sling66028802sling
slink95422912slink
slipe75626132slipe
spine76534422spine
spline86020532spline
swine85625302swine
tagline82412452tagline
thine85026852thine
tine45855132_tine
trine54734602trine
twine85822362twine
urine55026592urine
vahine123612112vahine
valines104520212valines
valise92917642valise
vine75643682_vine
wahine123813012wahine
waling104525302waling
whine116022812whine
wine74953422_wine
zine137036152_zine

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.0931921408.6
2DLD Change Limit538002552.03326463.4
3Display Results2552550.0763355.3
 (SQL Overall)1786912552.20281149.4
 
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.