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

171 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
erose5572727(None) 
arose55832081arose
brose75227031brose
erase54925491erase
erode64520991erode
eros45238451eros_
eroses65327051eroses
prose75835121prose
rerose63320841rerose
rose46148901_rose
acerose9310892acerose
aerobe8412402aerobe
ariose64818722ariose
arise56436432arise
arkose104911342arkose
arouse65019982arouse
arse46539272ar_se
broke116019782broke
brome94421972brome
bros65635662bros_
broses86524402broses
brosy106115382brosy
browse115713852browse
cerise84822042cerise
ceros74726072ceros_
ceruse83914522ceruse
chose105925402chose
close76425222close
corse75036182corse
crone75231332crone
crore74922862crore
cross75124502cross
crosse85216302crosse
crouse84619362crouse
croze164719452croze
cruse75726102cruse
depose94215762depose
dose56442432_dose
drone65324982drone
dross65418092dross
drove95518062drove
drowse105010552drowse
druse64817662druse
ease45042332e_ase
egos55821652egos_
elope75219342elope
else45923082e_lse
emote75421192emote
enrobe86610792enrobe
epode85114092epode
epos66723732epos_
eposes84418782eposes
eras45441502eras_
erased74816752erased
eraser64216332eraser
erases64425402erases
ere36352772er__e
ergs55523812ergs_
erne46727422er_ne
ernes55224812ernes
erns45428222erns_
eroded84313582eroded
erodes74819882erodes
erosely1038072erosely
erosive1039192erosive
errs45622532errs_
ers36046282er_s_
erses55826802er_ses
erst47436432er_st
euros54920242euros_
evoke12478852evoke
expose1549522expose
frise85322452frise
froe75329992fro_e
froes86126692froes
frore86218802frore
frosh115713402frosh
frost84727832frost
froze174515652froze
goose65925902goose
gorse65926812gorse
grope84821612grope
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grouse74315022grouse
grove95219332grove
gyrose105310252gyrose
heroes94923822heroes
heros84930862heros_
hexose16267842hexose
horse86132652horse
hose76547242_hose
irone55126362irone
ketose105711812ketose
krone94018732krone
leprose938542leprose
loose56627682loose
lose45144582_lose
moose76327192moose
morose85116242morose
morse76032702morse
necrose939722necrose
noose55624062noose
nose46739362_nose
operose939432operose
ose38147342__ose
perse75429522per_se
peruse84016842peruse
porose84818742porose
pose66441732_pose
prase76128752prase
prese75228382prese
prise74632612prise
probe94320812probe
prole74527792prole
prone75332622prone
pros65742782pros_
prosed94921092prosed
proser84223462proser
proses84733472proses
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
prove104823192prove
rase46149982_rase
repose84121412repose
rerise64325632rerise
reuse56025362reuse
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
serosa6313022serosa
serosae7310242serosae
setose65114772setose
terse55026822ter_se
those85218142those
torose64317692torose
torse55833332torse
triose64715382triose
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
uprose82311482uprose
urase54624682urase
venose9310842venose
verbose1237752verbose
verse84723582ver_se
whose114914532whose
worse86525262worse
wrote84717482wrote
xeroses143612822xeroses
zeroes154314342zeroes
zeros144918102zeros_

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 Limit538001711.79629955.5
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.93592346.8
 
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.