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 “trolly” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

509 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
trolly9401235(None) 
brolly114510851brolly
drolly105411671drolly
troll54416531troll_
trolley10328751trolley
trolls64613941trolls
colly104926772_colly
coolly114811392coolly
dolly96125202_dolly
droll65415402droll_
drolls75312392drolls
drooly104911072drooly
folly115022602_folly
frilly124111442frilly
golly95121102_golly
growly13499172growly
holly114824432_holly
jolly154517512_jolly
knolly13336132knolly
lolly85120662_lolly
molly105222492_molly
orally93113592orally
rally84725902_rally
roily86121112_roily
roll46331652_roll_
rolls55326232_rolls
stroll6311602stroll_
strolls739182strolls
tally84526862t_ally
telly84920822t_elly
toll45535262t_oll_
tolls54728432t_olls
tolyl84710092t_olyl
trebly1138972trebly
trigly103810942trigly
trilby1144972trilby
trill55122932trill_
trills64319852trills
trimly114410892trimly
triply114211022triply
trolled84312262trolled
troller73913172troller
trolleys11315692trolleys
trollop944792trollop
trollopy1343272trollopy
trophy1438282trophy
trotyl9236672trotyl
trouty95211792trouty
troy77429682tro__y
trull54012672trull_
trulls64110282trulls
truly84111552tr_uly
wholly15366572wholly
woolly12408512woolly
abolla8410193abolla
ally76935643__ally
anally9513503anally
apollo837183apollo
archly1437353archly
areally10411243areally
aridly105513703aridly
artily92814713artily
astrally1148883astrally
atoll57913923atoll_
atolls65511353atolls
atrophy1546183atrophy
aurally10310533aurally
bally105530103_bally
belly104625493_belly
billy105525363_billy
boldly12399423_boldly
boll65634753_boll_
bolls75531313_bolls
brawly144312353brawly
brill74819953brill_
brillo84211003brillo
brills84916293brills
broadly1337153broadly
broil74918223broil_
broils84114173broils
bronzy20306713bronzy
broody124510083broody
broomy13449953broomy
brosy106115383bro_sy
brothy14519623brothy
browny144510043browny
bully105124813_bully
chally144314293chally
chilly144113223chilly
cholla113911023cholla
coaly105521593_coaly
colby124415063_colby
coldly12459953_coldly
coly96940533_co_ly
cooly105525423_cooly
corolla938623corolla
coyly135614893_coyly
crawly144610763crawly
criollo943953criollo
croaky15528483croaky
crony105918673cro_ny
crossly1277273crossly
croupy13458733croupy
crowdy15467173crowdy
cruelly1236553cruelly
cully105520463_cully
dally95324743_dally
delly96023873_delly
dhooly13457143dhooly
dilly94923783_dilly
doily95321033_doily
doll56632493_doll_
dolls66126923_dolls
dooly94821803_dooly
doyly124514013_doyly
drably123511613drably
drawly134910723drawly
drill64718263drill_
drills74414203drills
drily95816523dr_ily
drolled93810223drolled
droller84110283droller
drollery12314793drollery
drool65416103drool_
drools74412813drools
droopy12458243droopy
dropsy12497473dropsy
drosky14486163drosky
drossy10528473drossy
drowsy13487903drowsy
drumly1235703drumly
dryly12538453dr_yly
dually103210063dually
dully94921633_dully
enroll61110073enroll_
enrolls7108093enrolls
erosely1038073erosely
evilly1236593evilly
felly114922803_felly
filly114424903_filly
foley115222303_foley
folky159214713_folky
foully1239013foully
frailly1337313frailly
freely12310953freely
frill84917563frill_
frills94414223frills
froggy1434493froggy
frolic1149203frolic
frosty124710633frosty
frothy15578373frothy
frouzy21395283frouzy
frowsy15498273frowsy
frowzy24485793frowzy
fully114820863_fully
gally95026173_gally
gilly94321633_gilly
girolle835793girolle
godly104913293_godly
goodly11419303goodly
googly11417883googly
gorily10612503gorily
grayly13287963grayly
greyly13316543greyly
grill64617893grill_
grille74315743grille
grills74314803grills
grimly12459933grimly
grisly104310583grisly
grody103412063gro_dy
groggy1234803groggy
groovy13375403groovy
grossly1175983grossly
groszy19395703groszy
grotty10389833grotty
grouty104710983grouty
growl96115823growl_
growls104711113growls
gully94020683_gully
gyrally1435583gyrally
hilly114422163_hilly
holey115626903_holey
holily123612953_holily
holla84918493_holla
hollo84822163_hollo
holy106333433_ho_ly
hooly115022223_hooly
hotly115815473_hotly
illy76925333__illy
irony85015903iro_ny
jelly154218253_jelly
jolty155713033_jolty
jowly186410903_jowly
jurally1736953jurally
kelly124617023_kelly
knoll9389603knoll_
knolls10367413knolls
krill94213643krill_
krills104211283krills
leally94012613leally
loll46128383_loll_
lolls512121733_lolls
lordly1038753lordly
lowly114113333_lowly
matronly1344783matronly
moldy115014653_moldy
moll66735703_moll_
molls75129783_molls
moly96031913_mo_ly
mooley11311633mooley
morally12411493morally
nelly84618813_nelly
nobly105314403_nobly
noily86120993_noily
oily77932253__oily
oldy85316843__oldy
olla44821173__olla
only75319723__only
orology11319463orology
outroll749303outroll_
outrolls847823outrolls
ovally12278443ovally
pally105727123_pally
patronly1344883patronly
poll66332133_poll_
polls74627723_polls
poly96235153_po_ly
poorly1137893poorly
portly114713403portly
prill74117943prill_
prills84015613prills
primly13439623primly
priorly12335763priorly
prolan8414693prolan
prole74527793pro_le
proleg94612113proleg
proles84627203proles
prolix1538683prolix
prolixly2043093prolixly
prolog94212973prolog
pronely12310243pronely
propyl13358183propyl
prosily12611633prosily
prosy106319253pro_sy
protyl11308213protyl
proudly1336323proudly
prowl105615123prowl_
prowls115511083prowls
proxy175011013pro_xy
quoll14379493quoll_
quolls15327303quolls
rallye95110163_rallye
rawly115115833_rawly
really93315613really
redly94217193_redly
refly113914563_refly
relay84424673_relay
rely75428953_r_ely
reply104015853_reply
reroll6412683reroll_
rerolls739943rerolls
retrally11310523retrally
riley84420583_riley
rill45140903_rill_
rille55728733_rille
rills55032713_rills
roble75223023_roble
rocky144513853_rocky
roil46235293_roil_
roils54826793_roils
role45851823_ro_le
roles56747983_roles
rolf75134873_ro_lf
rolfs84817123_rolfs
rolled74220243_rolled
roller63919793_roller
rollway1344653_rollway
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
ropey106021873_ropey
ropily113312443_ropily
ropy96323413_ro_py
rosily93914713_rosily
rosy76024873_ro_sy
rotl45029683_rotl_
rotls55620163_rotls
roupy106112713_roupy
rowdy125711533_rowdy
royally13157733_royally
ruly76323143_r_uly
rurally1038293rurally
sally85129713_sally
scroll8310163scroll_
scrolls938063scrolls
shelly124414463shelly
shoaly124010763shoaly
shrilly13318553shrilly
silly84527613_silly
slowly1237153slowly
smelly114110353smelly
solely93714213_solely
sonly85718053_sonly
sorely94618003sorely
stilly93714073stilly
strolled937813strolled
stroller848163stroller
strongly1245953strongly
stroppy14205093stroppy
stroy87720393stro__y
sully84622893_sully
taille63116923taille
talky126215683t_alky
tall47240213t_all_
talls55133433t_alls
tamely113711953tamely
tangly104413913tangly
tardily11269583tardily
tarnally1138273tarnally
tartily103511573tartily
tartly96014023tartly
tautly9499503tautly
tell44934703t_ell_
tells55828943t_ells
tellys9348843t_ellys
termly1138433termly
tersely1038103tersely
thalli958913thalli
thill85918733thill_
thills95515383thills
thinly1238663thinly
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholoi9339223tholoi
tholos94213003tholos
thorny12509843thorny
thrall93810293thrall_
thralls10299043thralls
thrill94910593thrill_
thrills10398783thrills
throaty13428483throaty
thusly1235133thusly
tidally1137933tidally
tiddly11308783tiddly
tidily102811393tidily
till45941203t_ill_
tills54631703t_ills
timely113410113timely
tingly103815963tingly
tinily94014433tinily
tinkly134811153tinkly
tiredly1136783tiredly
toady96814343t_oady
toby96322293t_o_by
today96416953t_oday
toddy106812423t_oddy
tody86327213t_o_dy
toffy145310283t_offy
toil46536283t_oil_
toile54626493t_oile
toils54527493t_oils
tokay125513053t_okay
tola45236333t_o_la
tolan55124013t_olan
tolar55524113t_olar
tolas54532773t_olas
told56132203t_o_ld
tole46052903t_o_le
toled65934923t_oled
toles55147133t_oles
tolled73819033t_olled
toller63819443t_oller
tollway1344793t_ollway
tolu45529153t_o_lu
tolus55024483t_olus
toluyl933443t_oluyl
tolyls9436963t_olyls
tommy124712233t_ommy
tonally10311373tonally
toney86027413t_oney
tony75635153t_o_ny
tool46735683t_ool_
tooled74918903tooled
tooler63818613tooler
tools55325243t_ools
toothy12529693toothy
tootle62613813tootle
tootsy9437983tootsy
torchy14549533torchy
torula6610393torula
tory75840543t_o_ry
totally1039893totally
towny116114493t_owny
towy105325473t_o_wy
toy69655193t_o__y
trail55126773trail_
trails64622513trails
trampy13499253trampy
tranny94210863tranny
trashy12509053trashy
trawl84915873trawl_
trawley13317303trawley
trawls94412393trawls
tray77632593tr__ay
treacly1237093treacly
treaty94414353treaty
treble8311663treble
trellis739873trellis
trembly1435523trembly
trendy10469603trendy
tressy9448553tressy
trevally1446343trevally
trey77228793tr__ey
trial54926353trial_
trials64319883trials
tribally1347323tribally
trickly16369893trickly
tricky154211473tricky
trifle94012883trifle
trilled84116313trilled
triller74215893triller
trilogy1136013trilogy
triol55521363triol_
triolet73219523triolet
triols66117803triols
triple84215923triple
trippy13457803trippy
tritely1039003tritely
troak95213573tro_ak
troaks104410593troaks
trocar848763trocar
troche113112513troche
trock114817603tro_ck
trocks123614633trocks
trod57627953tro__d
trode65322853tro_de
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troika1035493troika
troilus736403troilus
trois57226093tro_is
troke94821053tro_ke
troked114114583troked
trokes104019263trokes
troland837543troland
trollers83211203trollers
trolleyed1342473trolleyed
trollied935893trollied
trollies8310233trollies
trolling93212493trolling
trollops1044803trollops
trollying1354053trollying
tromp95815803tro_mp
trompe105611263trompe
tromps104911703tromps
trona54118953tro_na
tronas63816893tronas
trone55131863tro_ne
trones65629283trones
troop76417533tro_op
troops85712773troops
trooz145016153tro_oz
trop66833303tro__p
trope75725803tro_pe
tropes84824353tropes
tropic103014193tropic
tropin83316753tropin
trot46351313tro__t
troth85622203tro_th
troths95414153troths
trots56629943tro_ts
trotyls10236033trotyls
trouble957703trouble
trough108512023trough
troupe84812433troupe
trout57332573tro_ut
trouts66116623trouts
trove85221923tro_ve
trover95014663trover
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trowels10358363trowels
trows88826183tro_ws
trowth1277883trowth
troys86418613tro_ys
trusty94710113trusty
try66529673tr___y
tuille63012643tuille
tulle54019933t_ulle
twill85612723twill_
twills9489793twills
twirly12427083twirly
unroll61210073unroll_
unrolls797793unrolls
urology11217583urology
virally1339643virally
volley12419743_volley
wally114625093_wally
welly114620013_welly
willy115321913_willy
wooly114417673_wooly
worldly1433963worldly
wrongly1434553wrongly
wryly14356703wr_yly
yolky15529523_yolky

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165096.17318259.5
3Display Results5095090.1563262.8
 (SQL Overall)1786915096.46927622.7
 
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.