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

433 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
thorpes12501035(None) 
thorpe113610091thorpe_
thorps113610891thorp_s
chores114828022chor_es
herpes115517322_herpes
hopes105835642_ho_pes
hordes104921632_hordes
horses94729342_horses
shoppes143411392shoppes
shores94830412shor_es
theories11311592theories
theres96525472ther_es
thermes126214612thermes
tholes94919782tho_les
thoraces13118942thoraces
thoraxes1896362thoraxes
thorias102312052thorias
thorites11312392thorites
thorned11479402thorned
thorns95314102thor_ns
thorons104511912thorons
thorp104414262thorp__
threes97117322th_rees
throes97518672th_roes
thrones105715842thrones
thyrses1335022thyrses
topes76941762t_o_pes
tores55352672t_or_es
tories65435882t_ories
torses64727952t_orses
tortes64826052t_ortes
trompes114111622trompes
tropes84824352tro_pes
troupes94112852troupes
tsores65113662tsor_es
whores125617102whor_es
adores74420723ador_es
ahorse9311513ahorse_
bores76448253_bor_es
chapes135421873ch_apes
chares115631803char_es
charges134615983charges
chirped15379783chirped
chirper14359963chirper
chirpers15358133chirpers
chirps135414003chirp_s
chirres123812253chirres
choices142010613choices
chokes154917383cho_kes
chomped17329773chomped
chomper163810073chomper
chompers17369593chompers
chomps155112223chomp_s
chooses125717423chooses
chopped174511003chopped
chopper163611893chopper
choppers174110463choppers
chops125019873cho_p_s
chorales133712883chorales
chorals124614113chorals
chorded144710553chorded
chords125214633chor_ds
chore105126763chor_e_
chorea115216083chor_ea
choreas124414203choreas
chored125321883chor_ed
chorines132917253chorines
chorten122811303chorten
chortens13308793chortens
chortles133611323chortles
chorus115014773chor_us
choruses1339983choruses
choses115825133cho_ses
chouses125117813chouses
chowses155611283chowses
chromes142914933chromes
copes97747103_co_pes
cores76361853_cor_es
corps95927043_corp_s
corpse104013403_corpse
corpses113913803_corpses
corpus106015293_corpus
corses84433463_corses
corves115122523_corves
coupes105022523_coupes
crores86121163cror_es
croupes114613103croupes
dholes104914793dho_les
dopes84935043_do_pes
dories75232363_dories
dorper94314573_dorper
dorpers104113173_dorpers
dorps85419223_dorp_s
elopes85918163elo_pes
ethoses10311763etho_ses
ethoxies1845703ethoxies
forces114422133_forces
fores85847103_for_es
forges105024263_forges
formes114623713_formes
fortes95327183_fortes
glories81915913glories
gores65740373_gor_es
gorges85321893_gorges
gorps85316993_gorp_s
gorses74723293_gorses
gropes95220403gro_pes
hares86255543_har_es
harped124418403_harped
harper115018403_harper
harpers124916203_harpers
harpies123818313_harpies
harps105926873_harp_s
heres86245903_her_es
heroes94923823_heroes
hirees95117293_hirees
hires86134343_hir_es
hirples12149643_hirples
hoaxes163611693_hoaxes
hoboes114717443_hoboes
hoes75755733_ho__es
hoises94823673_hoises
hokes126231643_ho_kes
holes84748653_ho_les
holies94630033_holies
holpen11299413_holpen
homes106938813_ho_mes
homies114524723_homies
hones88144493_ho_nes
hooped125518183_hooped
hooper114518313_hooper
hoopers123616483_hoopers
hoopoes121212483_hoopoes
hoops105621073_hoop_s
hooves124815483_hooves
hope96639673_ho_pe_
hoped115628183_ho_ped
hoper105829143_ho_per
hopers114222973_ho_pers
hopped144318113_hopped
hopper134218483_hopper
hoppers143115143_hoppers
hopples142810713_hopples
hops97942633_ho_p_s
horahs126313873_horahs
horas86333103_hor_as
horde94623053_horde_
horded115420483_horded
horned105718703_horned
hornet94926433_hornet
hornets104113553_hornets
horns86125333_hor_ns
horse86132653_horse_
horsed105321083_horsed
horsey125115403_horsey
horstes104516113_horstes
horsts95817513_horsts
hoses85443173_ho_ses
houses96032273_houses
howes114730263_ho_wes
hoyles12315013_hoyles
hypes135818673_h_ypes
ivories10310713ivories
lopes76437343_lo_pes
lores55045403_lor_es
lories64933043_lories
loupes84918053_loupes
mopes95134983_mo_pes
mores76249643_mor_es
morphs13149433_morphs
myopes13419963myo_pes
opes65942613__o_pes
ores46056683__or_es
orles55326213__orles
phoebes1435813phoebes
phones114121213pho_nes
phonies123717513phonies
phorates13413043phorates
phoresy1534653phor_esy
popes95933813_po_pes
pores75849033_por_es
pyropes142210193pyropes
ropes75940063_ro_pes
scopes104719593sco_pes
scores84725923scor_es
shapes115124943sh_apes
shares95236413shar_es
sharped134112053sharped
sharpen12389723sharpen
sharpens13377813sharpens
sharper124312703sharper
sharpers133810943sharpers
sharpest1339143sharpest
sharpies13411223sharpies
sharps115516083sharp_s
sherpas1238093sherpas
shires95225573shir_es
shoes85429663sho__es
shoppe133110323shoppe_
shopped153512213shopped
shopper143312633shopper
shoppers153010763shoppers
shops104222903sho_p_s
shorans102812413shorans
shore85432653shor_e_
shored105723653shor_ed
shorls94516203shor_ls
shorted113614403shorted
shorten103511413shorten
shortens11288993shortens
shorter103515503shorter
shortest11310783shortest
shorties11414583shorties
shorts95321743shor_ts
shotes95321913sho_tes
shoves124919423sho_ves
slopes84820453slo_pes
snores64324323snor_es
sores55454283_sor_es
spores84726613spor_es
stirpes95011293stirpes
stopes84525893sto_pes
stores65533663stor_es
stories7324273stories
talipes9611603talipes
tapes75838603t__apes
tares57456563t_ar_es
targes74524593t_arges
tarps76527113t_arp_s
tarres64723043t_arres
tarries73324263tarries
taupes8212673t_aupes
terces83921413t_erces
ternes65422903t_ernes
terries73425633terries
thanes94918983th_anes
tharms115712243thar_ms
thebes115914493th_ebes
theines104013233theines
themes115319253th_emes
theorbos1343643theorbos
theorem1236273theor_em
theorems1344693theorems
theorise1137873theorise
theorises1247813theorises
theorizes2147073theorizes
therapies1447723therapies
there87527393ther_e_
therme115814993therme_
thermel12569893thermel
thermels13607763thermels
thermos124610753thermos
therms115914873ther_ms
theses96517973th_eses
thesps11448263thesp_s
thieves1346903thieves
thirams1236823thirams
thirds10438603thir_ds
thirled11328093thirled
thirls95012063thir_ls
thirsts1036243thirsts
thirties1139723thirties
thole85620843tho_le_
tholed105113873tho_led
tholos94213003tho_los
thonged12376843thonged
thongs104611193tho_ngs
thorax1638253thor_ax
thoria93012893thor_ia
thoric114314043thor_ic
thorite10313443thorite
thorium12208413thorium
thoriums13166403thoriums
thorn85318703thor__n
thornier1135323thornier
thorniest1236483thorniest
thornless1243633thornless
thorny12509843thor_ny
thoro86217873thor__o
thoron94713903thor_on
those85218143tho_se_
thoued10429003tho_ued
thous86017263tho__us
thowless1434613thowless
thraves13469713thraves
thraws129211103th_raws
three87526913th_r_ee
threep115910113th_reep
threeps12687043th_reeps
thresh12276863th_r_esh
threw1117315713th_r_ew
thrips11299013th_rips
thrives134611713thrives
throats104612193throats
throbs118311373th_robs
throe89321423th_roe_
throne98517603throne_
throned115412173throned
throngs11508163throngs
throve128012393throve_
thrower1386993thrower
throwers14106033throwers
throws129715233th_rows
thrums11429123th_rums
thumped15387413thumped
thumper14356953thumper
thumpers15365713thumpers
thumps13449353thump_s
thurls9418713thur_ls
thymes144810743th_ymes
thyrse1235133thyrse_
thyrsus1342693thyrsus
tierces93710453tierces
tires55437493t_ir_es
titres64718933titr_es
tobies84521023t_obies
todies74223553t_odies
toes46956443t_o__es
togues76014243t_ogues
toiles63923513t_oiles
tokes95234973t_o_kes
toles55147133t_o_les
tomes76037383t_o_mes
tones56048663t_o_nes
tonnes65320853t_onnes
toonies73719883toonies
tootles72915603tootles
tootses72910773tootses
tope65946383t_o_pe_
toped85631313t_o_ped
topee76029953t_o_pee
topees85519703t_opees
toper75231023t_o_per
topers85025323t_o_pers
tophes115218423t_ophes
tophs105220053t_o_phs
topis76025833t_o_pis
topos75726393t_o_pos
topped114617723t_opped
topper103817603t_opper
toppers113914603t_oppers
topples113111653t_opples
tops66248123t_o_p_s
toques154612353t_oques
torahs95115643t_orahs
toras55540373t_or_as
torches123715433t_orches
torcs75123763t_or_cs
tore47359323t_or_e_
torics85118353t_orics
toros54336193t_or_os
torose64317693t_orose
torous64319033t_orous
torpedo1035053t_orpedo
torpedos1143933t_orpedos
torpid9310913t_orpid
torpids1037373t_orpids
torpor839193t_orpor
torpors939383t_orpors
torques16217513t_orques
torrs53923563t_or_rs
tors46157383t_or__s
torse55833333t_orse_
torsks10549123t_orsks
torsos64815733t_orsos
tortas64918253t_ortas
torte55431703t_orte_
torten65314353t_orten
torts56138123t_or_ts
torus54329763t_or_us
toshes94520103t_oshes
tosses65225393t_osses
totes55139683t_o_tes
toupee8316133t_oupee
toupees938513t_oupees
touses64229673t_ouses
towies93521193t_owies
towropes1344953towropes
trapes85024463t_rapes
trees55835763t__rees
tres46542903t__r_es
tries55742813t__ries
tripes85324873t_ripes
troches123715343troches
trokes104019263tro_kes
trompe105611263trompe_
tromped124210293tromped
tromps104911703tromp_s
trones65629283tro_nes
trooped104010723trooped
trooper94210363trooper
troopers10289443troopers
troops85712783troop_s
trope75725803tro_pe_
troupe84812433troupe_
trouped103910983trouped
trouper93811433trouper
troupers10359443troupers
troves94719113tro_ves
trues54925323t__rues
tsoris63411193tsor_is
turps74918733t_urp_s
turves94212693t_urves
twerps11345153twerp_s
twirps11415013twirp_s
types105721063t__ypes
tyres84725233t_yr_es
unhorses1138453unhorses
wharves16457133wharves
wheres125917433wher_es
wherves16548053wherves
wholes124616773who_les
whomped18345473whomped
whomps16457603whomp_s
whooped16326933whooped
whoopee15287513whoopee
whoopees16294823whoopees
whooper15297153whooper
whoopers16286263whoopers
whoopies16267373whoopies
whoops14487863whoop_s
whopped18358003whopped
whopper17328503whopper
whoppers18297533whoppers
whops135013933who_p_s
whore116018043whor_e_
whored135512123whor_ed
whorled14366903whorled
whorls124410163whor_ls
whortles14306743whortles
whorts125111433whor_ts
worses95522953_worses
yores85031323_yor_es

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 Filter1786911340270.403443402.0
2DLD Change Limit1340274335.91022678.0
3Display Results4334330.1532830.1
 (SQL Overall)1786914336.46627635.5
 
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.