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

193 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
brose7522703(None) 
arose55832081arose
broke116019781broke
brome94421971brome
bros65635661bros_
broses86524401broses
brosy106115381brosy
browse115713851browse
erose55727271erose
prose75835121prose
rose46148901_rose
ariose64818722ariose
arise56436432arise
arkose104911342arkose
arouse65019982arouse
arse46539272ar_se
base64847022b_ase
biome94916992biome
bios66335322bios_
biros75325132biros_
birse74517402birse
bise66437102b_ise
blase75524232blase
bloke114316632bloke
blouse84714722blouse
bode75838752b_ode
bole66448692b_ole
bone65949322b_one
boos67955032boos_
boost75132472boost
booze164718912booze
bore66051332b_ore
bores76448252bores
borne77926792borne
bos57966812b_os_
bosh96328972b_osh
bosk105825732b_osk
boss65938342b_oss
bouse75931852bouse
bowse105420632bowse
brace95629272brace
brae65639112br_ae
braes75735052braes
braise84318752braise
brake116025342brake
bras65746452bras_
brash106221562brash
brass75428022brass
brave104925502brave
braze165423452braze
brede85520502brede
bree67241262br_ee
brees75632552brees
breve105317052breve
bribe94820782bribe
bride86425532bride
brie65837902br_ie
bries74942152bries
brine75132272brine
brios74725722brios_
bris65539612bris_
brises84927612brises
brisk115615982brisk
briss75824272briss
bro56236602bro__
broad84817692broad
broche133612102broche
brock136017072brock
brogue94211032brogue
broil74918222broil
broken124011522broken
broker124314242broker
bromes104719762bromes
bromo95217202bromo
bronc91714342bronc
bronze173610922bronze
broo65129822bro_o
brood84620242brood
brook114717762brook
broom95022212broom
broos75126412broos
broth106521092broth
brow97228442bro_w
browed125216392browed
brown105619532brown
brows105425982brows
browsed134511232browsed
browser124911142browser
browses124712692browses
bruise83412872bruise
brume95817982brume
brush105917472brush
brusk114912432brusk
brute75321782brute
burse75527252burse
chose105925402chose
close76425222close
corse75036182corse
crone75231332crone
crore74922872crore
cross75124502cross
crosse85216302crosse
crouse84619362crouse
croze164719452croze
cruse75726102cruse
dose56442432_dose
drone65324982drone
dross65418092dross
drove95518062drove
drowse105010552drowse
druse64817662druse
erase54925492erase
erode64520992erode
eros45238452eros_
eroses65327052eroses
frise85322452frise
froe75329992fro_e
froes86126692froes
frore86218802frore
frosh115713402frosh
frost84727832frost
froze174515652froze
goose65925902goose
gorse65926812gorse
grope84821612grope
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grouse74315022grouse
grove95219332grove
gyrose105310252gyrose
horse86132652horse
hose76547242_hose
irone55126362irone
krone94018732krone
loose56627682loose
lose45144582_lose
moose76327192moose
morose85116242morose
morse76032702morse
noose55624062noose
nose46739362_nose
ose38147342__ose
porose84818742porose
pose66441732_pose
prase76128752prase
prese75228382prese
prise74632612prise
probe94320812probe
prole74527792prole
prone75332622prone
pros65742782pros_
prosed94921092prosed
proser84223462proser
proses84733472proses
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
prove104823192prove
rase46149982_rase
rerose63320842rerose
rise45945232_rise
robe65335642_robe
rode55844302_rode
roe36861082_ro_e
roes45954142_roes
role45851822_role
roose56127092roose
rope65542912_rope
rosed65930342_rosed
roses56445772_roses
roset55945242_roset
rosy76024872_rosy
rote46249022_rote
roue45941742_roue
rouse56634702_rouse
rove75136982_rove
ruse45938932_ruse
those85218142those
torose64317692torose
torse55833332torse
triose64715382triose
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
uprose82311482uprose
urase54624692urase
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.310576422.6
2DLD Change Limit538001931.55034709.7
3Display Results1931930.0464195.7
 (SQL Overall)1786911931.90693751.8
 
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.