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

435 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
thorny1250984(None) 
horny115619621_horny
thorn85318701thorn_
thorns95314091thorns
corny106023272_corny
horn76735612_horn_
horns86125332_horns
horsy116318392_horsy
phony136715442pho_ny
porny106020192_porny
sharny124711832sharny
shorn85722172shorn_
shorty124313192shorty
theory121098352theor_y
thirty12378402thirty
thong95014172tho_ng
thorax1638252thorax
thoria93012882thoria
thoric114314032thoric
thorned11479402thorned
thornily1444152thornily
thoro86217872thor_o
thoron94713902thoron
thorons104511912thorons
thorp104414262thor_p
thorpe113610092thorpe
thorps113610892thorps
throne98517602throne
throng10539972throng
tony75635152t_o_ny
torn46044252t_orn_
tory75840542t_or_y
towny116114492t_owny
acorn75616623acorn_
acorns85013013acorns
adorn64917093adorn_
adorns74212613adorns
agony96415653ago_ny
ahorse9311513ahorse
ahoy101919183aho__y
althorn1047763althorn_
althorns1146723althorns
atony87218853ato_ny
attorn6310793attorn_
attorney1173723attorney
attorns738433attorns
barny105821733_barny
barony115915303barony
bethorn1238643bethorn_
bethorns1337323bethorns
bonny105816623_bonny
bony96732083_bo_ny
born67338413_born_
borne77926793_borne
borty105522833_borty
browny144510043browny
cairny11557823cairny
carny105822923_carny
charry145012113charry
chary135023133char_y
cherry144810763cherry
cherty144612473cherty
chirpy16498913chirpy
choana1138443choana
chokey184811713chokey
choky175711223cho_ky
chon96627793cho_n_
choosy14459103choosy
choppy18376293choppy
choral115118493choral
chord115917263chor_d
chords125214633chords
chore105126763chor_e
chorea115216083chorea
chored125321883chored
chores114828023chores
choric133515893choric
chorine123218363chorine
choring133617663choring
chorus115014763chorus
chromy16309903chromy
churn105113103churn_
churns114910233churns
cony96537833_co_ny
corby125018533_corby
corky145221153_corky
corn69945813_corn_
corns76034763_corns
cornu75921323_cornu
cory96941513_cor_y
crony105918673cro_ny
dehorn10439653dehorn_
dehorns11428363dehorns
dharna1055263dharna
dhooly13457143dhooly
dhurna1043563dhurna
dorky135518743_dorky
dormy115817463_dormy
dorty96220813_dorty
dory85836233_dor_y
downy125714553_downy
ebony104511513ebo_ny
ethoxy1933923etho_xy
ferny115816183_ferny
foray115023973_foray
forby135317673_forby
forky156119643_forky
forty114824273_forty
gharry13546273gharry
ghosty13467213ghosty
glory96413293glor_y
goony95519783_goony
gorsy95915783_gorsy
gory86129663_gor_y
hardy125622063_hardy
harpy136418203_harpy
harry115322953_harry
hawthorny2151553hawthorny
henry114014473_henry
herby134715313_herby
hern76134893_hern_
herns84825583_herns
herry114922473_herry
hinny115616673_hinny
hoagy124710473_hoagy
hoary114516763_hoary
hobby155913723_hobby
hokey155422183_hokey
holey115626903_holey
holly114824433_holly
holy106333433_ho_ly
homey135924843_homey
hominy144511483_hominy
homy126623223_ho_my
hon67759383_ho_n_
hone77549323_ho_ne
honey115629913_honey
hong85833953_ho_ng
honk116931193_ho_nk
honky156218523_honky
hons77350783_ho_ns
hoody124919723_hoody
hooey114926603_hooey
hooky155220263_hooky
hooly115022223_hooly
hooray123011373hooray
hooty115022433_hooty
hoppy154912353_hoppy
hora76136553_hor_a
horah117922043_horah
horal86328673_horal
horary12310383_horary
horas86333093_horas
horde94623053_horde
horned105718703_horned
hornet94926433_hornet
hornily1338283_hornily
horse86132653_horse
horsey125115403_horsey
horst85833513_horst
hosey116127023_hosey
hotly115815473_hotly
hound95016483_hound
hourly12369623_hourly
howdy155711413_howdy
hoy97447913_ho__y
hurly115819293_hurly
hurry114917183_hurry
irony85015903iro_ny
ivory1137373ivor_y
johnny1932193johnny
koruny1334443_koruny
loony86918963_loony
lorn46435253_lorn_
lorry86315663_lorry
lory75931713_lor_y
mony96830003_mo_ny
moony104818273_moony
moory105115793moor_y
moray105423793_moray
morn66237563_morn_
morns75527443_morns
orby97519603__orby
orgy85218003__orgy
peony105717563peo_ny
phon95925383pho_n_
phone105621933pho_ne
phoney143612983phoney
phono104917023pho_no
phons105221143pho_ns
phooey14379233phooey
phoresy1534653phoresy
pony96434053_po_ny
poorly1137893poorly
porgy116916123_porgy
porky145019333_porky
porn65636023_porn_
porno75120653_porno
porns75527343_porns
scorn75817443scorn_
scorns85713013scorns
shanny124110093shanny
sharn84823703sharn_
sharns95516983sharns
sharpy145211033sharpy
sheeny124912193sheeny
sherry124510413sherry
shinny124810783shinny
shiny115122143sh_iny
shirty124312553shirty
shoaly124010763shoaly
shoddy1434533shoddy
shone83725973sho_ne
shoon84022003shoon_
shoran94016033shoran
shorans102812403shorans
shore85432643shor_e
shored105723643shored
shores94830403shores
shoring112820063shoring
shorl84720243shor_l
shorls94516193shorls
short85040523shor_t
shortly13387563shortly
shorts95321733shorts
shown115216473shown_
showy145714003sho_wy
sonny85016103_sonny
sorn46641063_sorn_
sorns55028413_sorns
sorry84618253_sorry
spoony114111793spoony
sporty115112493sporty
stony85818643sto_ny
storey95217613storey
stormy115510723stormy
story86723033stor_y
swoony12408263swoony
sworn86115303sworn_
tardy94720463t_ardy
tarn46842723t_arn_
tarns56433953t_arns
tarry85422513t_arry
tarty86328183t_arty
tawny114713653t_awny
teary85124053tear_y
teeny85417883t_eeny
tern46134803t_ern_
terne56426153t_erne
terns55226873t_erns
terry84721873t_erry
tetany959843tetany
than76128773th_an_
thane86122533th_ane
thank125817803th_ank
tharm105916643thar_m
tharms115712243tharms
thegn95810903thegn_
thegnly1442613thegnly
thegns10547433thegns
thein85919023thein_
theine94814923theine
theins95015423theins
then78429693th_en_
thens85921833th_ens
theogony1543463theogony
theorbo1243743theorbo
theorem1236263theorem
therapy1536613therapy
there87527393ther_e
thereby1534633thereby
theres96525473theres
therm106018023ther_m
therme115814993therme
therms115914873therms
theurgy1442733theurgy
thewy146311853th_ewy
they107223753th__ey
thin76732383th_in_
thine85026853th_ine
thing96622963th_ing
think125018793th_ink
thinly1238663thinly
thins85826323th_ins
thionyl1343713thionyl
thir76420543thir__
thiram1139943thiram
third95912493thir_d
thirdly1444623thirdly
thirds10438603thirds
thirl85416823thir_l
thirls95012063thirls
thirst9312253thirst
thirsty1354083thirsty
tho67433963tho___
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholing112812333tholing
tholoi9339223tholoi
tholos94213003tholos
thongs104611183thongs
thorias102312043thorias
thorite10313443thorite
thorium12208403thorium
thornier1135323thornier
thorning1237513thorning
thorpes125010353thorpes
those85218143tho_se
thou76722213tho__u
thoued10429003thoued
though139410763though
thouing11258603thouing
thous86017253tho_us
thraw1110515923th_raw
three87526913th_ree
threw1117315713th_rew
thrip103012183th_rip
thro77726423th_r_o
throat94819753throat
throaty13428483throaty
throb109816853th_rob
throbs118311373throbs
throe89321423th_roe
throes97518673throes
throned115412173throned
thrones105715843thrones
throngs11508163throngs
throve128012393throve
throw118719733th_row
thrown1214911443thrown
throws129715233throws
thru76818943th_r_u
thrum104713633th_rum
thunk124911853th_unk
thurl84912683thur_l
thurls9418713thurls
thusly1235133thusly
thy97022913th___y
thymey17426313thymey
thymy16437923th_ymy
thyrse1235133thyrse
thyrsi1234453thyrsi
tinhorn1046023tinhorn_
tinhorns1145003tinhorns
tinny85317653t_inny
tiny76134633t__iny
toady96814343t_oady
toby96322293t_o_by
today96416953t_oday
toddy106812423t_oddy
tody86327213t_o_dy
toffy145310283t_offy
tokay125513053t_okay
tommy124712233t_ommy
ton310265103t_o_n_
tone46953743t_o_ne
toney86027413t_oney
tong56434353t_o_ng
tonne54921433t_onne
tons46553053t_o_ns
toon47740633t_oon_
toons55027533t_oons
toothy12529693toothy
tootsy9437983tootsy
tor39261683t_or__
tora47545993t_or_a
torah87125273t_orah
toras55540373t_oras
torc66333353t_or_c
torch107420933t_orch
torchy14549533t_orchy
torcs75123763t_orcs
tore47359323t_or_e
tores55352673t_ores
tori47542153t_or_i
toric76529313t_oric
torii55521593t_orii
toro48045683t_or_o
toros54336193t_oros
torot56139943t_orot
torr45630903t_or_r
torrs53923563t_orrs
tors46157383t_or_s
torse55833333t_orse
torsi57423363t_orsi
torsk94915773t_orsk
torso56922143t_orso
tort46967463t_or_t
torta55925353t_orta
torte55431703t_orte
torts56138123t_orts
torus54329763t_orus
tourney1036273tourney
town76928703t_own_
towns86018883t_owns
towy105325473t_o_wy
toy69655193t_o__y
tranny94210863tranny
tray77632593t__ray
trey77228793t__rey
trolly94012353trolly
trona54118953tro_na
trone55131863tro_ne
trophy1438283trophy
trouty95211793trouty
troy77429683t__roy
try66529673t__r_y
tsores65113663tsores
tsoris63411193tsoris
tunny86515033t_unny
turfy114315403t_urfy
turn46330383t_urn_
turns55623233t_urns
tweeny12477003tweeny
twiny116012813t_winy
twirly12427083twirly
wherry15477333wherry
whinny15587493whinny
whiny144915573wh_iny
whirly15448863whirly
whirry15477063whirry
wholly15366573wholly
whore116018043whor_e
whored135512123whored
whores125617103whores
whoring142910293whoring
whorl114612453whor_l
whorls124410163whorls
whort114623693whor_t
whorts125111433whorts
wordy126916163_wordy
wormy137514253_wormy
worn75631753_worn_
worry116114333_worry

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.280638182.1
2DLD Change Limit1127164356.33017806.6
3Display Results4354350.2032142.9
 (SQL Overall)1786914356.81326227.9
 
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.