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

423 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
axe10823949(None) 
ace59656831ace
ae212590291a_e
age47154331age
ale36572341ale
ane37866941ane
ape57251181ape
are37874571are
ate37059241ate
ave67748701ave
awe67746621awe
ax911057781ax_
axed128829611axed
axel115222071axel
axes117337851axes
axle116424601axle
aye67151761aye
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abbe87627182abbe
abed79734132abed
abet610547942abet
able66340532able
abo59045962abo
abs59356072abs
aby810238062aby
abye97921002abye
aced79540882aced
aces67645092aces
ache96829822ache
acme86924322acme
acne66625872acne
acre67330772acre
act59557842act
ad311975032a_d
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
adze1412820572adze
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
aged67334252aged
agee56241492agee
ager55935842ager
ages55844592ages
ago48845522ago
ags47551662ags
ague55725922ague
ah513868792a_h
aha611246642aha
ahed89536252ahed
ahem97225362ahem
ahi68040232ahi
ahs68644822ahs
ai211288392a_i
aid49269072aid
aide56044992aide
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
ajee115928232ajee
akee85936812akee
al210674042a_l
ala312463602ala
alae45643752alae
alb57342652alb
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
all36148232all
alme65832162alme
aloe45540192aloe
alp56641132alp
als36663022als
alt36467962alt
am411875562a_m
ama510853302ama
amen66733152amen
ami56646802ami
amie66339842amie
amp77541022amp
amu58237322amu
an211879072a_n
ana39559822ana
and47244162and
anes45255932anes
anew76623132anew
ani37751172ani
ant37270782ant
ante46538902ante
any68440482any
aped78538152aped
aper66336232aper
apes66047432apes
apex137220212apex
apo511142122apo
app76827602app
apse67725382apse
apt57352542apt
ar211379382a_r
arb510448422arb
arc510250902arc
area45843392area
ares45871022ares
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
arse46539272arse
art38679142art
as211083072a_s
asea46327182asea
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
ates45047922ates
att35454652att
auk76234142auk
ava610139322ava
aver75931882aver
aves76142602aves
avo68936232avo
aw512563402a_w
awa611939672awa
awed88436032awed
awee76336642awee
awes76037552awes
awl67635302awl
awn68035912awn
axal116520492axal
axels126313632axels
axil116424452axil
axile126020512axile
axis116127912axis
axite125218252axite
axled135315812axled
axles125219472axles
axmen145112272axmen
axon115524302axon
axone125918472axone
ay511773892a_y
ayes76543512ayes
ays67050292ays
azo128233392azo
babe86835812babe
bade75140882bade
bake105637512bake
bale66353842bale
bane65250422bane
bare65460522bare
base64847022base
bate66552422bate
be47948942_be
bee56262402bee
bye86134592bye
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
cane66653112cane
cape87242782cape
care66968372care
case65848082case
cate66254592cate
cave95941262cave
cee55952702cee
cue57544182cue
dace76934922dace
dale55643982dale
dame77140312dame
dare55848862dare
date56443322date
daze147327232daze
de37049542_de
dee47665822dee
dex116936882dex
die46759652die
doe47361952doe
due45249862due
dye75334842dye
ease45042332ease
eave75733582eave
eke75630092eke
eme55837182eme
ere36352772ere
eve66331162eve
ewe66630982ewe
ex98835642ex_
exec135313942exec
exed125420592exed
exes116530812exes
eye65539772eye
face96140122face
fade85736342fade
fake115534942fake
fame95639392fame
fane75343562fane
fare76354462fare
fate75444282fate
fave105532962fave
fax138143312fax_
faxed166220532faxed
faxes155726652faxes
faze165630042faze
fe57944742_fe
fee66862012fee
fie67152442fie
foe66350812foe
gae46457702gae
gage65936102gage
gale56347322gale
game76644322game
gane55145292gane
gape75134512gape
gate55746572gate
gave84634052gave
gaze145032412gaze
gee45359202gee
gie47149542gie
hade85440192hade
hae67364002hae
hake115637842hake
hale76052832hale
hame97043132hame
hare76255732hare
hate78450172hate
have106137072have
haze164833392haze
he58151952_he
hex137436172hex
hie67652702hie
hoe67562722hoe
hue66642302hue
ice56737242ice
ire36943172ire
jade125325442jade
jake155925772jake
jane115031472jane
jape134923422jape
jee106648642jee
joe106642352joe
kae76744542kae
kale86533752kale
kame105728232kame
kane85133962kane
kex146029582kex
kue76631862kue
kye107327272kye
lace66848472lace
lade56345982lade
lake85741602lake
lame66849292lame
lane45153322lane
lase46148512lase
late47560482late
lave75642142lave
lax107651522lax_
laxer125420332laxer
laxes125430092laxes
laze136235052laze
lee36068142lee
lex107943822lex
lie38264522lie
luxe115222692luxe
lye66533412lye
mabe85733342mabe
mace87345782mace
made75440232made
mae57659102mae
mage75739122mage
make105537882make
male66052292male
mane65052012mane
mare64759322mare
mate65154212mate
max129045442max_
maxed155821192maxed
maxes145629532maxes
maxi137023552maxi
maze155434972maze
me47748332_me
nabe66029492nabe
nae35952742nae
name65637412name
nape65230802nape
nave75732312nave
ne27045102_ne
nee36657782nee
nixe115722022nixe
obe56638642obe
ode47446582ode
oe28473062_oe
oke75839482oke
ole37155212ole
one37050912one
ope56845242ope
ore36661832ore
ose38147342ose
owe67041032owe
ox98242382ox_
oxen116218592oxen
oxes116530722oxes
oxo107322962oxo
oxy136320982oxy
pace86345772pace
page76036102page
pale66055012pale
pane64950282pane
pare66760842pare
pase65346862pase
pate65350462pate
pave96133892pave
pax127346852pax_
paxes144928422paxes
pe47649032_pe
pee56066512pee
pie55457402pie
pye86432502pye
race66746262race
rage55742352rage
rake84841572rake
rale45050562rale
rape65041632rape
rare45348432rare
rase46149982rase
rate45458762rate
rave75542092rave
rax108445722rax_
raxed135622662raxed
raxes124729392raxes
raze135235432raze
re26153742_re
ree37974072ree
rex105740992rex
roe36861072roe
rue35549262rue
rye66032542rye
sabe66140572sabe
sade55544472sade
sae38365182sae
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
same65245642same
sane45954332sane
sate45556102sate
save75741362save
sax107447642sax_
saxes125229342saxes
see35772262see
sex107043222sex
she66837692she
sue35651462sue
tace65342512tace
tae38267052tae
take84739262take
tale46154162tale
tame66343662tame
tape64538142tape
tare45957622tare
tate44748602tate
tax109449152tax_
taxa116820092taxa
taxed135620292taxed
taxer125019362taxer
taxes124730822taxes
taxi117124762taxi
tee38366872tee
the67436052the
tie36557532tie
toe310166852toe
tye65837442tye
uke75727292uke
use36835162use
ute35335882ute
vale74937342vale
vane75534682vane
vase75629652vase
vee65750182vee
vex136429172vex
vie65447632vie
voe67739052voe
wade85237062wade
wae67556952wae
wage84834082wage
wake114935702wake
wale74546432wale
wame95035482wame
wane76344712wane
ware76254722ware
wave105234732wave
wax137041182wax_
waxed166018482waxed
waxen154911812waxen
waxer154317482waxer
waxes155825502waxes
waxy175918202waxy
we57043452_we
wee66760812wee
woe66651242woe
wye96331972wye
xi98128162_xi
xu96018832_xu
yare75636942yare
ye57650062_ye
zax197630632zax_
zaxes215113822zaxes
zee126143232zee

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140844230.34341061.2
3Display Results4234230.0934548.4
 (SQL Overall)1786914230.499358098.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.