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

299 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
arses5573387(None) 
apses76823911apses
ares45871021ar_es
arises65233801arises
arles56735741arles
arse46539271arse_
arsis55722421arsis
asses55629281asses
carses85233651carses
erses55826801erses
marses84827111marses
parses85534701parses
rases55447211rases
abases85720772abases
abbes96723522abbes
ables75935542ables
abuses85119102abuses
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
adzes155913802adzes
aedes64625142aedes
aeries64737782aeries
ages55844592a_ges
agrees74915322agrees
agues64919052agues
aides65336602aides
aisles64721142aisles
akees96119242akees
ales47067102a_les
almes75126542almes
aloes54933672aloes
amies76837692amies
amuses85117942amuses
anes45255932a_nes
anises64826692anises
antes56334322antes
anuses66218772anuses
apes66047432a_pes
apres75426402apres
apse67725382apse_
apsis75718292apsis
araks94820882araks
arames84622572arames
arbs66834732ar_bs
arced88224162arced
arches114822042arches
arcs67834782ar_cs
arcus76918862arcus
arcuses94814692arcuses
ardeb8314522ardeb
ardebs937012ardebs
are37874572ar_e_
area45843392ar_ea
areas55935772areas
arenes64928392arenes
aretes64425352aretes
arfs76029962ar_fs
argles75218482argles
argues74516412argues
argus66716542argus
arguses84711742arguses
arias55438022arias
ariel55228972ariel
ariels65119372ariels
arils58732202arils
arise56436432arise_
arisen65316792arisen
arkoses113910832arkoses
arks85936872ar_ks
armed86324432armed
armer76924442armer
armers85520272armers
armet76739452armet
armets84918352armets
armies85123692armies
arms66137492ar_ms
arose55832082arose_
arouses74921292arouses
arpen74418042arpen
arpens84814822arpens
arras55626132arras
arrases71214542arrases
arrest63722632arrest
arris56824682arris
arrises71617582arrises
ars37670932ar__s
arseno6318912arseno
arsines73518812arsines
arson55118832arson
arsons63917212arsons
artel56122742artel
artels66216232artels
arts49650262ar_ts
arums75517832arums
arvos86015662arvos
aryls87015812aryls
asea46327182a_sea
ashes86230612ashes
asks85721212a_sks
asps65622092a_sps
ass37844062a_s_s
assess65710462assess
asset55932262asset
assets65617662assets
ates45047922a_tes
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axises134413992axises
axles125219472axles
ayes76543512a_yes
baases85218012baases
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barres84427542barres
baryes116218502baryes
bases75644352bases
basses85428302basses
beses75830722beses
birses84717732birses
bises75435622bises
braes75735052braes
brees75632552brees
bries74942152bries
brises84927612brises
broses86524402broses
burses84425512burses
buses75936012buses
cares77369182car_es
caress85720262caress
caries85147622caries
carles85435082carles
carse74934332carse_
cartes86239472cartes
carves115128452carves
cases75048382cases
causes88026472causes
corses84433462corses
coses76949492coses
crases85532312crases
cress75022832cress
cries75438402cries
crises84529432crises
cruses88127712cruses
curses85328272curses
daises74318982daises
dares66146702dar_es
doses65938502doses
drees65628522drees
dress65319832dress
dries64733672dries
druses75517252druses
eases56041612eases
erases64425402erases
ernes55224812ernes
eroses65327052eroses
eses45336102_eses
esses56422972esses
farces115223322farces
fares85852872far_es
farles96025782farles
frees86131392frees
fries85535602fries
frises94124272frises
froes86126692froes
fuses85628422fuses
gases65633992gases
gasses75724782gasses
gorses74723292gorses
grees65132472grees
grues65721962grues
hanses95022632hanses
hares86255542har_es
hawses125113992hawses
hearses104414532hearses
horses94729342horses
hoses85443172hoses
ires45639282ir_es
irises64221172irises
karsts106012942karsts
krises105016082krises
lapses85217692lapses
larees65323112larees
lares54852632lar_es
larges74824232larges
lases54944762lases
lasses64827592lasses
leses54930812leses
loses56742012loses
lyses84518252lyses
manses84225512manses
mares76457632mar_es
marges94525712marges
marse76231152marse_
marshes123615372marshes
masses85028712masses
mises74740562mises
muses75134302muses
nares55544152nar_es
noses55435642noses
nurses63919352nurses
oases55330982oases
ores46056682or_es
orles55326212orles
oses46641512_oses
pares77164482par_es
pareses94718882pareses
parges94529542parges
paries84742512paries
parises94827182parises
parles86334402parles
parse75236992parse_
parsec105914482parsec
parsecs11429922parsecs
parsed96323892parsed
parser84822372parser
parsers94118152parsers
pases75346502pases
passes86030472passes
pauses84621472pauses
perses85428062perses
poses74642762poses
prases84429022prases
prees75937172prees
press75425952press
pries74339532pries
prises84133172prises
proses84733472proses
purses84826372purses
puses75532202puses
races74943242races
rages64539442rages
raises64826542raises
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rares55247442rares
rase46149982rase_
rased65033932rased
raser55633412raser
rasers64526782rasers
rashes95330152rashes
rasps74316662rasps
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
rees45364192_rees
res35565042_r_es
rises55244042rises
roes45954132_roes
roses56445772roses
rues46044482_rues
ruses56136582ruses
ryes75529352_ryes
sarees65329942sarees
sarges75128592sarges
saroses73619332saroses
sarsen6314232sarsen
sarsens7311392sarsens
sasses64124392sasses
sises55233832sises
tares57456562tar_es
targes74524592targes
tarres64723042tarres
tarsus6310512tarsus
tasses64826762tasses
tawses94913192tawses
torses64727952torses
trees55835762trees
tres46542902tr_es
tress55423162tress
tries55742812tries
trues54925322trues
urases63723562urases
urges64619912urges
uruses63616502uruses
uses44931112_uses
valses94514612valses
varies94330872varies
varuses10310622varuses
varves124414782varves
vases84626262vases
verses94223762verses
vises84427772vises
wares88250582war_es
warsles103413642warsles
wises85633192wises
worses95522952worses
wries85827742wries
yeses85119322yeses

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 Limit538002991.78030224.7
3Display Results2992990.0803737.5
 (SQL Overall)1786912991.95391495.6
 
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.