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

174 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
axles12521947(None) 
ables75935541ables
ales47067101a_les
arles56735741arles
axels126313631axels
axes117337851ax_es
axle116424601axle_
axled135315811axled
aals49941142aal_s
abbes96723522abbes
abeles84719392abeles
able66340532able_
abled86926832abled
abler75624312abler
ablest84721832ablest
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
addles84216602addles
adzes155913802adzes
aedes64625142aedes
ages55844592a_ges
aglee65728492aglee
aglet65534142aglet
aglets73915682aglets
agley96917332agley
agues64919052agues
aides65336602aides
ailed66240282ailed
ails45654712ail_s
aisles64721142aisles
akees96119242akees
alas46358122a_las
albs68628572a_lbs
ale36572342a_le_
alec66430062a_lec
alecs76620732a_lecs
alee46652322a_lee
alef76340692a_lef
alefs87319662a_lefs
allee54932122allee
allees64521482allees
alley85721672alley
alleys95113302alleys
allies63827672allies
alls46740922a_lls
almes75126542almes
alms65834922a_lms
aloes54933672aloes
alps65529242a_lps
als36663022a_l_s
alts46639902a_lts
ambles105121852ambles
amies76837682amies
amoles84122192amoles
aneles64626292aneles
anes45255932a_nes
angles74426702angles
ankles104818382ankles
anlas55626932anlas
anoles64827422anoles
antes56334322antes
apes66047432a_pes
apples104315762apples
apres75426402apres
apses76823912apses
ares45871022a_res
argles75218482argles
arses55733872arses
ashes86230612ashes
asses55629282asses
ates45047922a_tes
atlas55821582atlas
aures55137092aures
aves76142602a_ves
awes76037552a_wes
awless939262awless
awls75926092awl_s
axe108239492ax_e_
axed128829612ax_ed
axel115222072ax_el
axile126020512axile_
axils127217502axils
axis116127912ax_is
axises134413992axises
axites134913832axites
axmen145112272axmen
axones134614512axones
axons125517932axons
ayes76543512a_yes
azoles154614612azoles
bales76250082bales
biles75542142biles
boles75448602boles
cables104527552cables
calxes154113032calxes
carles85435082carles
caules85927252caules
coles76055062coles
dales66439742dales
dalles74222062dalles
deles65139252deles
doles67843752doles
eagles73819162eagles
exes116530812ex_es
exiles134816402exiles
fables114921672fables
farles96025782farles
faxes155726652fax_es
files85441272files
gables94222332gables
gales65442482gales
gules64831042gules
hales85449842hales
haoles94919802haoles
holes84748652holes
idles66720122idles
isles54220562isles
ixtles13217062ixtles
joles125230832joles
kales95730982kales
kayles134712002kayles
ladles74619542ladles
laxes125430092lax_es
les35663072__les
macles107023222macles
mailes84329112mailes
males75049792males
maples104819422maples
maxes145629532max_es
miles74645072miles
moles74747922moles
mules75034292mules
ogles65223182ogles
oles46453472_oles
orles55326212orles
oxes116530722ox_es
padles95221112padles
pales75753802pales
parles86334392parles
paxes144928422pax_es
peles75738082peles
piles74742612piles
poles75351002poles
pules74538812pules
rales54947492rales
raxes124729392rax_es
riles55343642riles
roles56747982roles
rules55234252rules
sables85026692sables
sales56055592sales
saxes125229342sax_es
soles55547922soles
tables84524882tables
tales55451372tales
taxes124730822tax_es
taxies135817332taxies
taxless1436902taxless
teles54536002teles
tiles55542102tiles
toles55147132toles
tules54532792tules
vales85434262vales
voles86234042voles
wales86142832wales
waxes155825502wax_es
wiles85437872wiles
wyles114615322wyles
yules84521582yules
zaxes215113822zax_es

Search took 2 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 Limit538001741.83029398.9
3Display Results1741740.0463782.6
 (SQL Overall)1786911741.96990752.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.