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

322 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
arse4653927(None) 
apse67725381apse
are37874571ar_e
ares45871021ares
arise56436431arise
arose55832081arose
ars37670931ars_
arses55733871arses
carse74934331carse
marse76231151marse
parse75236991parse
rase46149981rase
aas310975392aas_
abase76023482abase
abbe87627192abbe
able66340532able
abs59356072abs_
abuse77119562abuse
abye97921002abye
ace59656832a_ce
aces67645092aces
ache96829822ache
acme86924322acme
acne66625872acne
acre67330772acre
acres76327762acres
ads49755732ads_
adze1412820572adze
ae212590292a__e
aerie54634602aerie
age47154332a_ge
agee56241492agee
ages55844592ages
agree65226032agree
ags47551662ags_
ague55725922ague
ahorse9311512ahorse
ahs68644822ahs_
aide56044992aide
airs46447422airs_
ais39083572ais_
aisle55223192aisle
ajee115928232ajee
akee85936812akee
alae45643752alae
ale36572342a_le
alee46652322alee
ales47067102ales
alme65832162alme
aloe45540192aloe
als36663022als_
also46423442also
amie66339852amie
amuse75920832amuse
ane37866942a_ne
anes45255932anes
anise55129702anise
ansa45927772ansa
ansae55720972ansae
ante46538902ante
ape57251182a_pe
apes66047432apes
apres75426402apres
apses76823912apses
ar211379382ar__
arak86929572arak
arame75026622arame
arb510448422ar_b
arbs66834732arbs
arc510250902ar_c
arced88224162arced
arch98628442arch
arco68331542arco
arcs67834782arcs
ardeb8314522ardeb
area45843392area
areae55229742areae
arene55329412arene
arete56031352arete
arf67453372ar_f
arfs76029962arfs
argle65421562argle
argue64818442argue
aria46245422aria
arid57642712arid
ariel55228972ariel
aril45843022aril
ariose64818722ariose
arisen65316792arisen
arises65233802arises
ark77044962ar_k
arkose104911342arkose
arks85936872arks
arles56735742arles
arm58449622ar_m
armed86324432armed
armer76924442armer
armet76739452armet
arms66137492arms
army96624182army
arouse65019982arouse
arpen74418042arpen
arseno6318912arseno
arsine64021042arsine
arsis55722422arsis
arson55118832arson
art38679142ar_t
artel56122742artel
arts49650262arts
artsy86012962artsy
arty77531312arty
arum66129032arum
arvo76023432arvo
aryl75922342aryl
as211083072a_s_
asea46327182a_sea
ash67944602a_sh
ask77130702a_sk
asp57235342a_sp
ass37844062a_ss
asses55629282asses
asset55932262asset
ate37059242a_te
ates45047922ates
aurae54128112aurae
aures55137092aures
ave67748702a_ve
averse95811182averse
aves76142602aves
awe67746622a_we
awee76336642awee
awes76037552awes
axe108239492a_xe
axes117337852axes
axle116424602axle
aye67151762a_ye
ayes76543512ayes
ays67050292ays_
barbe95328282barbe
barde85330772barde
bare65460522bar_e
bares75457132bares
barge85631022barge
barre75929542barre
bars66564092bars_
barye105021492barye
base64847022base
birse74517402birse
bise66437102bise
brae65639112brae
bree67241262bree
brie65837902brie
brose75227032brose
burse75527252burse
care66968372car_e
cares77369182cares
carle74535702carle
cars67364762cars_
carses85233652carses
carte75940422carte
carve106227752carve
case65848082case
cause75225352cause
coarse84813892coarse
corse75036182corse
cruse75726102cruse
curse75829142curse
dare55848862dar_e
dares66146702dares
dose56442432dose
dree56638322dree
druse64817662druse
ears46356592ears_
ease45042332ease
else45923082else
erase54925492erase
ere36352772er_e
erne46727422erne
erose55727272erose
ers36046282ers_
erses55826802erses
erst47436432erst
false84818122false
farce104925322farce
fare76354462far_e
fares85852872fares
farle86929242farle
frae75330472frae
free75940182free
frise85322452frise
froe75329992froe
fuse76429992fuse
gars55750742gars_
gorse65926812gorse
gree56641562gree
grue55825712grue
hanse85722792hanse
hare76255732har_e
hares86255542hares
harsh116418052harsh
hawse116015122hawse
hearse94114272hearse
hoarse94411322hoarse
horse86132652horse
hose76547242hose
ire36943172ir_e
ires45639282ires
jars117338352jars_
karst97228992karst
lapse74917682lapse
laree56036292laree
lares54852632lares
large65325462large
lars46956572lars_
lase46148512lase
lose45144582lose
lyse76320592lyse
manse75528222manse
mare64759322mar_e
mares76457632mares
marge85328332marge
mars66261862mars_
marses84827112marses
marsh105320852marsh
masse75125292masse
mise66043582mise
morse76032702morse
muse67136032muse
nares55544152nares
nose46739362nose
nurse54420122nurse
oars46846032oars_
ore36661832or_e
ores46056682ores
orle45630462orle
ors35750112ors_
ose38147342_ose
owse76321622owse
paise75028332paise
parae76335702parae
pare66760842par_e
pares77164482pares
parge85831852parge
parle75836162parle
pars67560792pars_
parsec105914472parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parve109824852parve
pase65346862pase
passe75525692passe
pause75021832pause
perse75429522perse
pose66441732pose
prase76128752prase
pree67044732pree
prese75228382prese
prise74632612prise
prose75835122prose
purse76028892purse
race66746262race
rage55742352rage
raise54828052raise
rake84841572rake
rale45050562rale
rape65041632rape
rare45348432rare
rares55247442rares
ras37575392ras_
rased65033932rased
raser55633412raser
rases55447212rases
rash76039932rash
rasp66029162rasp
rate45458762rate
rave75542092rave
raze135235432raze
re26153742_r_e
ree37974072_ree
res35565042_res
rise45945232rise
roe36861072_roe
rose46148902rose
rue35549262_rue
ruse45938932ruse
rye66032542_rye
saree55044662saree
sarge65531132sarge
sarsen6314232sarsen
sparse84516342sparse
tare45957622tar_e
tares57456562tares
targe65227092targe
tarre55825632tarre
tars46763952tars_
tarsi55222172tarsi
tasse54821842tasse
tawse85616502tawse
terse55026822terse
torse55833332torse
tree47745812tree
tres46542902tres
true46725852true
urase54624682urase
urge54722412urge
ursa44116902ursa
ursae55214452ursae
use36835162_use
valse85117522valse
vars75742072vars_
varve115716852varve
vase75629652vase
verse84723582verse
vise75632672vise
ware76254722war_e
wares88250582wares
wars78659802wars_
warsle93112922warsle
wise75737342wise
worse86525262worse
yare75636942yar_e

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 Filter178691298720.0762351197.4
2DLD Change Limit298723221.04628558.3
3Display Results3223220.0804025.0
 (SQL Overall)1786913221.202148661.4
 
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.