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

461 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
thorpe11361009(None) 
thorp104414261thorp_
thorpes125010351thorpes
thorps113610891thorps
ahorse9311512ahorse
chore105126762chor_e
hope96639672_ho_pe
horde94623052_horde
horse86132652_horse
shoppe133110312shoppe
shore85432642shor_e
there87527392ther_e
therme115814992therme
thole85620842tho_le
thorax1638252thorax
thoria93012882thoria
thoric114314032thoric
thorite10313442thorite
thorn85318702thor_n
thorned11479402thorned
thorns95314092thorns
thorny12509842thorny
thoro86217872thor_o
thoron94713902thoron
those85218142tho_se
three87526912th_ree
throe89321422th_roe
throne98517602throne
throve128012392throve
thyrse1235132thyrse
tope65946382t_o_pe
tore47359322t_or_e
torse55833332t_orse
torte55431702t_orte
trompe105611262trompe
trope75725802tro_pe
troupe84812432troupe
whore116018042whor_e
adore65723663ador_e
afore85818603afor_e
agorae7511203agorae
ashore9414613ashor_e
bore66051333_bor_e
borne77926793_borne
chape125221143ch_ape
chare105231983char_e
charge125114213charge
chirp124717163chirp_
chirped15379783chirped
chirper14359963chirper
chirps135414003chirps
chirpy16498913chirpy
chirre114111853chirre
choice132010523choice
choke145118023cho_ke
chomp144815663chomp_
chomped17329773chomped
chomper163810073chomper
chomps155112223chomps
choose115116143choose
chop116024923cho_p_
chopped174511003chopped
chopper163611893chopper
choppy18376293choppy
chops125019873cho_ps
choral115118493choral
chorale124313353chorale
chord115917263chor_d
chorded144710553chorded
chords125214633chords
chorea115216083chorea
chored125321883chored
chores114828023chores
choric133515893choric
chorine123218363chorine
chorten122811303chorten
chortle124210443chortle
chorus115014763chorus
chose105925403cho_se
chouse116017563chouse
chowse144711753chowse
chrome133214813chrome
cope86847383_co_pe
core67263113_cor_e
corps95927043_corps
corpse104013403_corpse
corse75036183_corse
coupe96023483_coupe
crore74922863cror_e
croupe105114433croupe
dhole95215363dho_le
dope76038893_do_pe
dore56353303_dor_e
dorp76028053_dorp_
dorper94314563_dorper
dorps85419223_dorps
elope75219343elo_pe
florae94713883florae
force105324273_force
fore78351473_for_e
forge95126943_forge
forme105225993_forme
forte86131463_forte
frore86218803fror_e
gore55744963_gor_e
gorge76423893_gorge
gorp75625903_gorp_
gorps85316993_gorps
gorse65926813_gorse
grope84821613gro_pe
hare76255733_har_e
harp96134283_harp_
harped124418403_harped
harper115018403_harper
harps105926863_harps
harpy136418203_harpy
here76447103_her_e
herpes115517323_herpes
hire75538963_hir_e
hiree85427803_hiree
hirple11158973_hirple
hoarse94411323_hoarse
hoe67562723_ho__e
hoise85224773_hoise
hoke115935933_ho_ke
hole77553393_ho_le
holp95727553_holp_
holpen11299413_holpen
home98042443_ho_me
homie104622523_homie
hone77549323_ho_ne
hoop96129983_hoop_
hooped125518183_hooped
hooper114518313_hooper
hoopoe11911233_hoopoe
hoops105621073_hoops
hop87554593_ho_p_
hoped115628183_ho_ped
hoper105829143_ho_per
hopes105835643_ho_pes
hopped144318113_hopped
hopper134218483_hopper
hopple132910483_hopple
hoppy154912353_hoppy
hops97942633_ho_ps
hora76136553_hor_a
horah117922043_horah
horal86328673_horal
horas86333093_horas
horded115420483_horded
hordes104921633_hordes
horn76735613_hor_n
horned105718703_horned
hornet94926433_hornet
horns86125333_horns
horny115619623_horny
horsed105321083_horsed
horses94729343_horses
horsey125115403_horsey
horst85833513_horst
horste94817413_horste
horsy116318393_horsy
hose76547243_ho_se
house89131423_house
hove107132223_ho_ve
howe106734103_ho_we
hoyle11314413_hoyle
hype125519813_h_ype
kore85834163_kor_e
lope65941923_lo_pe
lore45850353_lor_e
loupe75319513_loupe
mope86838043_mo_pe
morae75831193_morae
more67154523_mor_e
morph121712513_morph
morse76032703_morse
myope124010973myo_pe
nope65934193_no_pe
oorie53026363_oorie
ope56845243__o_pe
ore36661833__or_e
orle45630463__orle
phoebe1335003phoebe
phone105621933pho_ne
phorate12413363phorate
pope85535613_po_pe
pore66451263_por_e
pyrope132810533pyrope
rope65542913_ro_pe
scope94821483sco_pe
score75526733scor_e
shape105125113sh_ape
share86437083shar_e
sharp104922533sharp_
sharped134112043sharped
sharpen12389723sharpen
sharper124312703sharper
sharpie1238383sharpie
sharps115516083sharps
sharpy145211033sharpy
sherpa1138093sherpa
shire84727133shir_e
shoe75933433sho__e
shone83725973sho_ne
shop95629833sho_p_
shopped153512203shopped
shopper143312623shopper
shoppes143411383shoppes
shops104222893sho_ps
shoran94016033shoran
shored105723643shored
shores94830403shores
shorl84720243shor_l
shorls94516193shorls
shorn85722173shor_n
short85040523shor_t
shorted113614393shorted
shorten103511403shorten
shorter103515493shorter
shortie10411323shortie
shorts95321733shorts
shorty124313193shorty
shote85526083sho_te
shove114421033sho_ve
shrove125412223shrove
slope75823563slo_pe
snore55424953snor_e
sore47059533_sor_e
spore75428593spor_e
stope74727243sto_pe
store56333813stor_e
swore84920813swor_e
tape64538143t__ape
tare45957623t_ar_e
targe65227093t_arge
tarp66936413t_arp_
tarps76527113t_arps
tarre55825633t_arre
taupe7314163t_aupe
terce75721843t_erce
terne56426153t_erne
terrae62915203terrae
terse55026823t_erse
thae76825563th__ae
thane86122533th_ane
tharm105916643thar_m
tharms115712243tharms
the67436053th___e
thebe107515433th_ebe
thecae11299653thecae
thee78039063th__ee
theine94814923theine
theme105921733th_eme
thence112010843thence
theorbo1243743theorbo
theorem1236263theorem
theories11311593theories
theorise1137873theorise
theorize2047063theorize
theory121098353theor_y
therapy1536613therapy
theres96525473theres
therm106018023ther_m
thermae125310493thermae
thermel12569893thermel
thermes126214613thermes
therms115914873therms
these86519013th_ese
thesp105410313thesp_
thesps11448263thesps
thieve1235963thieve
thine85026853th_ine
thir76420543thir__
thiram1139943thiram
third95912493thir_d
thirds10438603thirds
thirl85416823thir_l
thirled11328093thirled
thirls95012063thirls
thirst9312253thirst
thirty12378403thirty
tho67433963tho___
tholed105113873tholed
tholes94919783tholes
tholoi9339223tholoi
tholos94213003tholos
thong95014173tho_ng
thonged12376833thonged
thongs104611183thongs
thoraces13118933thoraces
thoraxes1896353thoraxes
thorias102312043thorias
thorites11312393thorites
thorium12208403thorium
thornier1135323thornier
thorons104511913thorons
thou76722213tho__u
thoued10429003thoued
though139410763though
thous86017253tho_us
thrave126010273thrave
thraw1110515923th_raw
threep115910113th_reep
threes97117323th_rees
threw1117315713th_rew
thrice114311573thrice
thrip103012183th_rip
thrips11299013thrips
thrive125313223thrive
thro77726423th_r_o
throat94819753throat
throb109816853th_rob
throbs118311373throbs
throes97518673throes
throned115412173throned
thrones105715843thrones
throng10539973throng
throw118719733th_row
thrower1386993thrower
thrown1214911443thrown
throws129715233throws
thru76818943th_r_u
thrum104713633th_rum
thump126211573thump_
thumped15387413thumped
thumper14356953thumper
thumps13449353thumps
thurl84912683thur_l
thurls9418713thurls
thyme134612473th_yme
thyrses1335013thyrses
thyrsi1234453thyrsi
tierce8339843tierce
tire46143353t_ir_e
titre54619393titr_e
toe310166853t_o__e
togae67020113t_ogae
togue64816303t_ogue
toile54626493t_oile
toke86738493t_o_ke
tole46052903t_o_le
tome67543193t_o_me
tone46953743t_o_ne
tonne54921433t_onne
toonie63617993toonie
tootle62613813tootle
top510560683t_o_p_
toped85631313t_o_ped
topee76029953t_opee
toper75231023t_o_per
topes76941763t_o_pes
toph96326873t_o_ph
tophe106718973t_ophe
topi67830393t_o_pi
topo66932403t_o_po
topped114617723t_opped
topper103817603t_opper
topple104411323t_opple
tops66248123t_o_ps
toque145113093t_oque
tor39261683t_or__
tora47545993t_or_a
torah87125273t_orah
toras55540373t_oras
torc66333353t_or_c
torch107420933t_orch
torcs75123763t_orcs
tores55352673t_ores
tori47542153t_or_i
toric76529313t_oric
tories65435883t_ories
torii55521593t_orii
torn46044253t_or_n
toro48045683t_or_o
toros54336193t_oros
torose64317693t_orose
torot56139943t_orot
torpedo1035053t_orpedo
torpid9310913t_orpid
torpor839193t_orpor
torque15237673t_orque
torr45630903t_or_r
torrs53923563t_orrs
tors46157383t_or_s
torses64727953t_orses
torsi57423363t_orsi
torsk94915773t_orsk
torso56922143t_orso
tort46967463t_or_t
torta55925353t_orta
torten65314353t_orten
tortes64826053t_ortes
torts56138123t_orts
torus54329763t_orus
tory75840543t_or_y
tote46643673t_o_te
toupee8316133t_oupee
touse55430673t_ouse
towie85821873t_owie
towrope1245583towrope
tree47745813t__ree
tripe75425383t_ripe
troche113112513troche
trode65322853tro_de
troke94821053tro_ke
tromp95815803tromp_
tromped124210293tromped
trompes114111623trompes
tromps104911703tromps
trone55131863tro_ne
troop76417533troop_
trooped104010723trooped
trooper94210353trooper
troops85712773troops
trop66833303tro_p_
tropes84824353tro_pes
trouped103910973trouped
trouper93811413trouper
troupes94112843troupes
trove85221923tro_ve
true46725853t__rue
tsores65113663tsores
tsoris63411193tsoris
turps74918733t_urps
twerp10398413twerp_
twerps11345153twerps
twirp10468943twirp_
twirps11415013twirps
type96223743t__ype
tyre75428253t_yr_e
unhorse1038583unhorse
wharve15456203wharve
where117019423wher_e
wherve15568113wherve
whole114418093who_le
whomp155011323whomp_
whomped18345473whomped
whomps16457603whomps
whoop134211443whoop_
whooped16326933whooped
whoopee15287513whoopee
whooper15297153whooper
whoopie15295913whoopie
whoops14487863whoops
whop125520923who_p_
whopped18358003whopped
whopper17328503whopper
whops135013933who_ps
whored135512123whored
whores125617103whores
whorl114612453whor_l
whorled14366903whorled
whorls124410163whorls
whort114623693whor_t
whortle13335943whortle
whorts125111433whorts
whose114914533who_se
wore77144673_wor_e
worse86525263_worse
yore76335943_yor_e

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.1261418182.5
2DLD Change Limit1127164616.18618221.1
3Display Results4614610.1403292.9
 (SQL Overall)1786914616.45227695.4
 
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.