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

314 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
arles5673574(None) 
ables75935541ables
ales47067101a_les
ares45871021ar_es
argles75218481argles
arses55733871arses
axles125219471axles
carles85435081carles
farles96025781farles
orles55326211orles
parles86334401parles
rales54947491rales
aals49941142aal_s
abbes96723522abbes
abeles84719392abeles
able66340532able_
abled86926832abled
abler75624312abler
ablest84721832ablest
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
addles84216602addles
adzes155913802adzes
aedes64625152aedes
aeries64737782aeries
ages55844592a_ges
aglee65728492aglee
aglet65534142aglet
aglets73915682aglets
agley96917332agley
agrees74915322agrees
agues64919052agues
aides65336602aides
ailed66240282ailed
ails45654712ail_s
airless73712042airless
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
ambles105121862ambles
amies76837692amies
amoles84122192amoles
aneles64626292aneles
anes45255932a_nes
angles74426702angles
ankles104818382ankles
anlas55626932anlas
anoles64827432anoles
antes56334322antes
apes66047432a_pes
apples104315762apples
apres75426402apres
apses76823912apses
arables91814972arables
araks94820882araks
arames84622572arames
arbs66834732ar_bs
arced88224162arced
arches114822042arches
arcs67834782ar_cs
arcus76918862arcus
ardeb8314522ardeb
ardebs937012ardebs
are37874572ar_e_
area45843392ar_ea
areas55935772areas
arenes64928392arenes
areoles71016952areoles
aretes64425352aretes
arfs76029962ar_fs
argle65421562argle_
argled85314552argled
argues74516412argues
argus66716542argus
argyles1136052argyles
arias55438022arias
ariel55228972ariel
ariels65119372ariels
ariled75620322ariled
arils58732202arils
arise56436432arise
arises65233802arises
arks85936872ar_ks
armed86324432armed
armer76924442armer
armers85520272armers
armet76739452armet
armets84918352armets
armies85123692armies
armless9369942armless
armlet84118192armlet
armlets94610062armlets
arms66137492ar_ms
arose55832082arose
arpen74418042arpen
arpens84814822arpens
arras55626132arras
arrest63722632arrest
arris56824682arris
ars37670932ar__s
arse46539272arse_
arsis55722422arsis
artel56122742artel
artels66216232artels
artless73712512artless
arts49650262ar_ts
arums75517832arums
arvos86015662arvos
aryls87015812aryls
ashes86230612ashes
asses55629282asses
ates45047922a_tes
atlas55821582atlas
aures55137092aures
aves76142602a_ves
awes76037552a_wes
awless939262awless
awls75926092awl_s
axels126313632axels
axes117337852a_xes
axle116424602axle_
axled135315812axled
ayes76543512a_yes
azoles154614612azoles
bales76250082bales
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barless94317002barless
barley115116762barley
barleys125011842barleys
barres84427542barres
baryes116218502baryes
biles75542142biles
birles84920642birles
boles75448602boles
braes75735052braes
brees75632552brees
bries74942152bries
cables104527552cables
cares77369182car_es
caries85147622caries
carle74535702carle_
carless95118492carless
carls77037422carl_s
carses85233652carses
cartes86239472cartes
carves115128452carves
caules85927252caules
coles76055062coles
cries75438402cries
dales66439742dales
dalles74222062dalles
dares66146702dar_es
darkles124011932darkles
dartles84014132dartles
deles65139252deles
doles67843752doles
drees65628522drees
dries64733672dries
eagles73819162eagles
earless74316072earless
earls56127512earl_s
ernes55224812ernes
erses55826802erses
fables114921672fables
farces115223322farces
fares85852872far_es
farle86929242farle_
farls85731112farl_s
files85441272files
frees86131392frees
fries85535602fries
froes86126692froes
gables94222332gables
gales65442482gales
garbles104016922garbles
gargles94214892gargles
grees65132472grees
grues65721962grues
gules64831042gules
hales85449842hales
haoles94919802haoles
hares86255542har_es
harls85634502harl_s
holes84748652holes
idles66720122idles
ires45639282ir_es
isles54220562isles
jarls126120962jarl_s
joles125230832joles
kales95730982kales
kayles134712002kayles
ladles74619542ladles
larees65323112larees
lares54852632lar_es
larges74824232larges
les35663072__les
macles107023222macles
mailes84329112mailes
males75049792males
maples104819422maples
marbles114516652marbles
mares76457632mar_es
marges94525712marges
marled95523162marled
marls75535162marl_s
marses84827112marses
merles85322762merles
miles74645072miles
moles74747922moles
mules75034292mules
nares55544152nar_es
oarless73913372oarless
ogles65223182ogles
oles46453472_oles
ores46056682or_es
orle45630462orle_
padles95221122padles
pales75753802pales
pares77164482par_es
parges94529542parges
paries84742512paries
parle75836162parle_
parled94626292parled
parley116718362parley
parleys125212372parleys
paroles95025882paroles
parses85534702parses
peles75738082peles
piles74742612piles
poles75351002poles
prees75937172prees
pries74339532pries
proles84627202proles
pules74538812pules
races74943242races
rages64539442rages
rajes125022782rajes
rakes94440352rakes
rale45050562rale_
rapes75740722rapes
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
rees45364192_rees
res35565042_r_es
riles55343642riles
roes45954142_roes
roles56747982roles
rues46044482_rues
rules55234252rules
ryes75529352_ryes
sables85026692sables
sales56055592sales
sarees65329942sarees
sarges75128592sarges
soles55547922soles
tables84524892tables
tales55451372tales
tares57456562tar_es
targes74524592targes
tarres64723042tarres
teles54536002teles
tiles55542102tiles
toles55147132toles
trees55835762trees
tres46542902tr_es
tries55742812tries
trues54925322trues
tules54532792tules
urges64619912urges
vales85434262vales
varies94330872varies
varlet9423502varlet
varlets10411572varlets
varves124414782varves
voles86234042voles
wales86142832wales
warbles123215562warbles
wares88250582war_es
warless104015102warless
warsles103413642warsles
wiles85437872wiles
wries85827742wries
wyles114615322wyles
yules84521582yules

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.313570897.8
2DLD Change Limit538003141.48336277.8
3Display Results3143140.0933376.3
 (SQL Overall)1786913141.88994595.6
 
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.