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

200 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
arose5583208(None) 
ariose64818721ariose
arise56436431arise
arkose104911341arkose
arouse65019981arouse
arse46539271ar_se
brose75227031brose
erose55727271erose
prose75835121prose
rose46148901_rose
abase76023482abase
abode85518812abode
abos67734412abos_
above105414322above
abuse77119562abuse
acerose9310892acerose
across8312642across
adobe84814702adobe
adore65723662adore
ados57633512ados_
adoze155713832adoze
aerobe8412402aerobe
afore85818602afore
agarose838652agarose
agone65924552agone
ahorse9311512ahorse
aldose7311092aldose
aloe45540192alo_e
aloes54933672aloes
alone55732962alone
amole75724592amole
amuse75920832amuse
anise55129702anise
anode65021032anode
anole55330372anole
apos65433822apos_
appose10411992appose
apse67725382a_pse
arame75026622arame
arbs66834732arbs_
arcs67834782arcs_
are37874572ar__e
areae55229742areae
arene55329412arene
arenose7311372arenose
areole61017282areole
ares45871022ares_
arete56031352arete
arfs76029962arfs_
argle65421562argle
argosy1036422argosy
argue64818442argue
ariosi64313032ariosi
arioso64312402arioso
arisen65316792arisen
arises65233802arises
arkoses113910832arkoses
arks85936872arks_
arles56735742arles
arms66137492arms_
aroid65428332aroid
aroma71220142aroma
aroused84914342aroused
arouser74514422arouser
arouses74921292arouses
ars37670932ar_s_
arses55733872ar_ses
arson55118832arson
arts49650262arts_
artsy86012962artsy
arvos86015662arvos_
atone56527982atone
avos77227012avos_
avoset9315672avoset
awoke124912002awoke
axone125918472axone
azole145118032azole
azote144416342azote
broke116019782broke
brome94421972brome
bros65635662bros_
broses86524402broses
brosy106115382brosy
browse115713852browse
carouse9614422carouse
carse74934332car_se
chose105925402chose
close76425222close
corse75036182corse
crone75231332crone
crore74922862crore
cross75124502cross
crosse85216302crosse
crouse84619362crouse
croze164719452croze
cruse75726102cruse
dose56442432_dose
drone65324982drone
dross65418092dross
drove95518062drove
drowse105010552drowse
druse64817662druse
erase54925492erase
erode64520992erode
eros45238452eros_
eroses65327052eroses
faros85532022faros_
frise85322452frise
froe75329992fro_e
froes86126692froes
frore86218802frore
frosh115713402frosh
frost84727832frost
froze174515652froze
garote7717942garote
goose65925902goose
gorse65926812gorse
grope84821612grope
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grouse74315022grouse
grove95219332grove
gyrose105310252gyrose
horse86132652horse
hose76547242_hose
irone55126362irone
kaross101910012kaross
krone94018732krone
lanose6313592lanose
loose56627682loose
lose45144582_lose
marse76231152mar_se
moose76327192moose
morose85116242morose
morse76032702morse
narcose95910382narcose
noose55624062noose
nose46739362_nose
ose38147342__ose
parole84425252parole
parse75236992par_se
porose84818742porose
pose66441732_pose
prase76128752prase
prese75228382prese
prise74632612prise
probe94320812probe
prole74527792prole
prone75332622prone
pros65742782pros_
prosed94921092prosed
proser84223462proser
proses84733472proses
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
prove104823192prove
raise54828052raise
ramose8314402ramose
rase46149982_rase
rerose63320842rerose
rise45945232_rise
robe65335642_robe
rode55844302_rode
roe36861072_ro_e
roes45954132_roes
role45851822_role
roose56127092roose
rope65542912_rope
rosed65930342_rosed
roses56445772_roses
roset55945242_roset
rosy76024872_rosy
rote46249022_rote
roue45941742_roue
rouse56634702_rouse
rove75136982_rove
ruse45938932_ruse
sarode75317512sarode
saros55238062saros_
saroses73619332saroses
taros55640822taros_
those85218142those
torose64317692torose
torse55833332torse
triose64715382triose
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
uprose82311482uprose
urase54624682urase
vadose1037962vadose
vamose1159282vamose
whose114914532whose
worse86525262worse
wrote84717482wrote

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 Limit538002001.62633087.3
3Display Results2002000.0603333.3
 (SQL Overall)1786912001.779100444.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.