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

188 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
acne6662587(None) 
ace59656831ac_e
ache96829821ache
acme86924321acme
acned87520671acned
acnes75922621acnes
acre67330771acre
ane37866951a_ne
cane66653121cane
abbe87627192abbe
able66340532able
abye97921002abye
aced79540882aced
aces67645092aces
ached119227832ached
achene11313812achene
aches106132292aches
achy126316092achy
acid77533392acid
acing87429152acing
acini75718982acini
ackee115825372ackee
acmes96020652acmes
acnode938202acnode
acred87126352acred
acres76327762acres
act59557842ac_t
acta69524802acta
acted88521732acted
acts66929862acts
acute74720362acute
acyl95314292acyl
adze1412820572adze
ae212590292a__e
age47154332a_ge
agee56241492agee
agene65621582agene
agone65924552agone
ague55725922ague
aide56045002aide
ain37579092ain_
ains46158882ains
ajee115928232ajee
akee85936812akee
akene95818662akene
alae45643752alae
alane56135612alane
ale36572342a_le
alee46652322alee
aline57243152aline
alme65832162alme
aloe45540192aloe
alone55732962alone
amen66733152amen
amie66339852amie
amine75835382amine
an211879082a_n_
ana39559832a_na
ancone83916952ancone
and47244172a_nd
anes45255932a_nes
anew76623132a_new
ani37751182a_ni
anna45529012anna
annex12310882annex
ant37270792a_nt
ante46538902ante
any68440492a_ny
ape57251182a_pe
apnea73413412apnea
apse67725382apse
arcane81216742arcane
are37874572a_re
arene55329412arene
arse46539272arse
ate37059242a_te
atone56527982atone
aunt46553652aunt
ave67748702a_ve
awe67746622a_we
awee76336642awee
awn68035912awn_
awned96615952awned
awns75324432awns
awny105919302awny
axe108239492a_xe
axle116424602axle
axone125918472axone
aye67151762a_ye
azine146721412azine
bane65250432bane
bene66439492bene
bine66650862bine
bone65949322bone
cache125122482cache
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
can57760142can_
caned85838092caned
caner75334772caner
canes75350372canes
canoe75627252canoe
cans65050852cans
cant66362032cant
cape87242782cape
care66968372care
case65848082case
cate66254602cate
cave95941262cave
cee55952702_cee
cine66242942cine
cone67256962cone
cue57544182_cue
dace76934922dac_e
dance85223132dance
dene56643412dene
dine55555332dine
done55747912done
dune56137582dune
dyne85320932dyne
eche97520282eche
erne46727432erne
esne47018792esne
eyne76322462eyne
face96140122fac_e
fane75343572fane
fine75147952fine
gane55145302gane
gene56237222gene
gone55639042gone
hance105424152hance
hone77549322hone
ice56737242ic_e
jane115031482jane
kane85133972kane
kine85643432kine
kune85424572kune
lace66848472lac_e
lacune8169672lacune
lance75126722lance
lane45153332lane
line46965572line
lone45849132lone
lune47140492lune
mace87345792mac_e
mache125925302mache
macle96127002macle
mane65052032mane
mine67256172mine
nacre75715362nacre
nance74721842nance
ne27045102__ne
nene45932062nene
nine45842172nine
none45743172none
once65423082once
one37050912_one
pace86345772pac_e
pane64950292pane
panne76623652panne
pine67755712pine
pone65747532pone
race66746262rac_e
rance75028512rance
rune45236302rune
sane45954342sane
scene77220572scene
scone74621832scone
sene46848052sene
sine46560622sine
sone46649982sone
syne75725762syne
tace65342512tac_e
tache106222372tache
tine45855132tine
tone46953742tone
tune45635862tune
tyne76325052tyne
vane75534692vane
vine75643682vine
wacke145918622wacke
wane76344722wane
wine74953422wine
zine137036152zine
zone135231082zone

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 Filter178691298720.686260482.5
2DLD Change Limit298721882.11014157.3
3Display Results1881880.0335697.0
 (SQL Overall)1786911882.82963164.0
 
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.