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

226 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
arise5643643(None) 
anise55129701anise
ariose64818721ariose
arisen65316791arisen
arises65233801arises
arose55832081arose
arse46539271ar_se
frise85322451frise
prise74632611prise
raise54828051raise
rise45945231_rise
abase76023482abase
abide86223712abide
abris75722602abris_
abuse77119562abuse
advise10139222advise
aerie54634602aeri_e
aeries64737782aeries
afire86215912afire
agile65122262agile
agism84614062agism
agist66325582agist
ahis76135382ahis_
aide56045002a_ide
airs46447422airs_
airwise1036712airwise
ais39083572a_is_
aisle55223192a_isle
alike95523962alike
aline57243152aline
alist56136782alist
alive85722512alive
amice96122872amice
amide86128482amide
amie66339852ami_e
amies76837692amies
amine75835382amine
amis66445322amis_
amiss75823072amiss
amuse75920832amuse
anile54634462anile
anime75423202anime
anis45746462anis_
anises64826692anises
aorist64827872aorist
apish105116632apish
apprise11310192apprise
apse67725382a_pse
arame75026622arame
arbs66834732arbs_
arcs67834782arcs_
are37874572ar__e
areae55229742areae
arene55329412arene
ares45871022ares_
arete56031352arete
arfs76029962arfs_
argle65421562argle
argue64818442argue
aria46245422ari_a
arias55438022arias
arid57642712ari_d
arider74717742arider
ariel55228972ariel
aril45843022ari_l
ariled75620322ariled
arils58732202arils
ariosi64313032ariosi
arioso64312402arioso
arista6415292arista
aristae7312532aristae
aristo6414032aristo
arkose104911342arkose
arks85936872arks_
arles56735742arles
armies85123692armies
arms66137492arms_
arouse65019982arouse
arris56824682arris_
arrises71617582arrises
arrive91311792arrive
ars37670932ar_s_
arses55733872ar_ses
arsine64021042arsine
arsis55722422arsis
artist64125542artist
artiste73813692artiste
arts49650262arts_
artsy86012962artsy
aside65122082aside
auris55331532auris_
aurist65027252aurist
aviso85713962aviso
axile126020512axile
axis116127912axis_
axised14438962axised
axises134413992axises
axite125218252axite
azide155617162azide
azine146721412azine
barite84224812barite
birse74517402birse
bise66437102_bise
braise84318752braise
bribe94820782bribe
bride86425532bride
brie65837902bri_e
bries74942152bries
brine75132272brine
bris65539612bris_
brises84927612brises
brisk115615982brisk
briss75824272briss
brose75227032brose
bruise83412872bruise
camise103319632camise
caribe103416752caribe
caries85147622caries
carse74934332car_se
cerise84822042cerise
cries75438402cries
crime94822692crime
cripe95521142cripe
cris66233432cris_
crises84529432crises
crisp95014622crisp
cruise84314042cruise
cruse75726102cruse
dries64733672dries
drive95318002drive
druse64817662druse
erase54925492erase
erose55727272erose
fraise94214912fraise
fries85535602fries
frisee94217992frisee
frises94124272frises
frisk125312372frisk
garish104516922garish
gride75223582gride
grilse7399502grilse
grime85021322grime
gripe84622962gripe
grist65529872grist
guise64717712guise
hoise85224772hoise
iris45732552iris_
irised73913152irised
irises64221172irises
kris86423602kris_
krises105016082krises
larine63927042larine
laris54737462laris_
marine84230402marine
marish114319052marish
marse76231152mar_se
mise66043582_mise
narine63422552narine
naris55735292naris_
noise55723732noise
paise75028332paise
paries84742512paries
paris75145942paris_
parises94827182parises
parish115022352parish
parse75236992par_se
parvise124211692parvise
pavise114714802pavise
peise75825772peise
poise75127892poise
praise84419412praise
prase76128752prase
prese75228382prese
price93725412price
pride84724732pride
pries74339532pries
prime96525602prime
prised94322202prised
prises84133172prises
prism94820262prism
priss74623892priss
prize164718942prize
prose75835122prose
rais45252622rais_
raised76120332raised
raiser66620102raiser
raises64826542raises
rase46149982_rase
rerise64325632rerise
rice64942912_rice
ride55945132_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
rinse54820972_rinse
ripe66038922_ripe
risen54621882_risen
riser55431052_riser
rises55244042_rises
risk85724102_risk
rite45849452_rite
rive75537722_rive
rose46148902_rose
ruse45938932_ruse
saris54544952saris_
seise54727852seise
sris45434152sris_
tribe74420272tribe
trice75127492trice
tries55742812tries
trike95320162trike
trine54734602trine
triose64715382triose
tripe75425382tripe
triste63818642triste
trite54730032trite
uprise82313692uprise
urase54624692urase
urine55026602urine
valise92917642valise
varies94330872varies
vise75632672_vise
wise75737342_wise
wries85827742wries
wrist84827562wrist
write85522832write

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.310576422.6
2DLD Change Limit538002261.51635488.1
3Display Results2262260.0633587.3
 (SQL Overall)1786912261.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.