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

443 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
thresh1227686(None) 
thrash12258361thrash
thrush12257481thrush
afresh1255502afresh
fresh115012202_fresh
resh76523452__resh
sheesh1237812sheesh
tares57456562tares_
theres96525472theres_
these86519012th_ese
thesp105410312th_esp
thread105011092thread
threap11569662threap
threat95020462threat
three87526912thre_e
threep115910112threep
threes97117322threes
threshed1535642threshed
thresher1455822thresher
threshes1437382threshes
threw1117315712thre_w
throes97518672throes_
thrust91911892thrust
tires55437492tires_
tores55352672tores_
trash86119762t_rash
tres46542902t_res_
tress55423162t_ress
tyres84725232tyres_
acres76327763acres_
airest63825263airest
apres75426403apres_
ares45871023_ares_
arrest63722633arrest
aures55137093aures_
bares75457133bares_
barest85327693barest
bores76448253bores_
brash106221563_brash
brush105917473_brush
byres104421383byres_
cares77369183cares_
caress85720263caress
ceres75540013ceres_
chares115631803chares_
cheese113812763cheese
cheesy14419193cheesy
cherish15310463cherish
chess105016923ch_ess
chest104926143ch_est
cheth135013823ch_eth
chores114828023chores_
choush14549063choush
chrism13710673chrism
cires74932913cires_
cores76361853cores_
crash109120013_crash
creesh11328333creesh
cress75022833_cress
crest74632693_crest
crush106815993_crush
cures75645433cures_
dares66146703dares_
direst75024243direst
dress65319833_dress
drest65530343_drest
dures65635923dures_
duress74712063duress
egress73310433egress
enmesh1134893enmesh
etherish1448273etherish
ethers94518413ethers_
eyres84921773eyres_
fares85852873fares_
feres86038183feres_
fires85740753fires_
flesh115013743_flesh
fores85847103fores_
forest94926743forest
frosh115713403_frosh
garish104516923garish
ghees95215553ghees_
girsh95310023gir_sh
gores65740373gores_
gursh94512333gur_sh
gyres94820323gyres_
haes77651023_haes_
hares86255543hares_
harsh116418053_harsh
hash106936503_h_ash
heh96039623_h_e_h
hehs106723963_h_ehs
heres86245903heres_
heresy125011233heresy
hers75844873_hers_
hes66654203_h_es_
hest75950773_h_est
heth107028023_h_eth
hies74842833_hies_
hires86134343hires_
hoes75755733_hoes_
hues75235233_hues_
hush105224113_h_ush
immesh1334113immesh
inmesh1134863inmesh
inrush936513inrush
ires45639283_ires_
kheth15509753kh_eth
lares54852633lares_
lores55045403lores_
lures56138533lures_
lyres85019963lyres_
mares76457633mares_
marish114319053marish
marsh105320853mar_sh
meres75143573meres_
merest84725113merest
mesh96823003__mesh
mires75640883mires_
mores76249643mores_
mures75937223mures_
nares55544153nares_
ochres113510833ochres_
ogreish1134673ogreish
ogres65818633ogres_
ogress7529503ogress
ogrish1039263ogrish
onrush935343onrush
ores46056683_ores_
others93918003others_
pares77164483pares_
parish115022353parish
peres76246643peres_
perish114619063perish
phoresy1534653phoresy
phrase11109903phrase
phreak1536153phreak
phrensy1533623phrensy
pores75849033pores_
presa74319043_presa
prese75228383_prese
press75425953_press
prest75736353_prest
purest84021933purest
pyres105523883pyres_
qursh174110843qur_sh
qurush1835503qurush
rares55247443rares_
rarest65725483rarest
rash76039933__rash
refresh1335453refresh
res35565043__res_
rest46459843__rest
rush76628183__rush
seres55448893seres_
serest64831613serest
shares95236413shares_
shes75734353sh_es_
shies86136553shies_
shiest95821533shiest
shires95225573shires_
shoes85429663shoes_
shores94830413shores_
shred98125613shre_d
shreds105613053shreds
shrew119720173shre_w
shrewd136810783shrewd
shrewish1744743shrewish
shrews129313923shrews
shris84221453shris_
shush113812543sh_ush
shyest125511833shyest
sires55945373sires_
sneesh945893sneesh
sores55454283sores_
sorest65028003sorest
stares66038753stares_
steres63929533steres_
stores65533663stores_
stress66616673stress
surest65026763surest
tabes76033923tabes_
taces76237803taces_
tahrs85412333tahr_s_
tajes124920693tajes_
takes94437793takes_
tales55451373tales_
tames75242013tames_
tamest85721293tamest
tapes75838603tapes_
tarbush1234173tarbush
tare45957623tare__
tared69340053tare_d
targes74524593targes_
tarnish101611873tarnish
tarns56433953tarns_
taros55640823taros_
tarps76527113tarps_
tarres64723043tarres_
tars46763953tar_s_
tarsi55222173tar_si
tartest72517533tartest
tartish101512633tartish
tarts57242023tarts_
tates55444983tates_
taxes124730823taxes_
tech95925443t__ech
tees45353583t_ees_
teeth87315853t_eeth
teles54536003teles_
teraph11319093teraph
terces83921413terces_
teredo7310783teredo
terefah1344113terefah
terete6319333terete
terms75523473terms_
ternes65422903ternes_
terns55226873terns_
terse55026823ter_se
terser67317823terser
tersest71713993tersest
test48651623t__est
teth76327893t__eth
thae76825563thae__
thanes94918983thanes_
tharms115712243tharms_
thatch1435613thatch
thaws116515463thaws_
the67436053th_e__
thebe107515433th_ebe
thebes115914493thebes_
theca103311453th_eca
thee78039063th_e_e
theft114118133th_eft
thegn95810903th_egn
thein85919023th_ein
their85512153th_eir
theism1139483theism
theist9314763theist
them97427043th_e_m
theme105921733th_eme
themes115319253themes_
then78429693th_e_n
thens85921833th_ens
there87527393th_ere
thereat104315243thereat
thereby1534633thereby
therein102310353therein
thereof13168063thereof
thereon10199263thereon
thereto1038993thereto
therm106018023th_erm
therme115814993therme
thermes126214613thermes_
therms115914873therms
theses96517973th_eses
thesis94913733th_esis
thesps11448263th_esps
theta83414573th_eta
thew108226233th_e_w
thews117416193th_ews
thewy146311853th_ewy
they107223753th_e_y
thief114516303thie_f
thieve1235963thieve
thievish1743263thievish
thigh12410123th_igh
thighs1346633thighs
thins85826333thins_
thirds10438603thirds_
thirls95012063thirls_
thirst9312253thirst
this76027383th_is_
tholes94919783tholes_
thorns95314103thorns_
thorpes125010353thorpes_
thorps113610893thorps_
those85218143th_ose
though139410783though
thous86017263thous_
thrall93810293thrall
thrashed1555363thrashed
thrasher1455743thrasher
thrashes1487653thrashes
thrave126010273thrave
thraves13469713thraves_
thraw1110515923thr_aw
thrawn12769423thrawn
thraws129211103thraws
threads11419953threads
thready14435903thready
threaps12488643threaps
threats104311673threats
threeps12687043threeps
threshers1545423threshers
threshing1645663threshing
threshold1642913threshold
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrive125313223thrive
thrives134611713thrives_
thro77726423thr__o
throat94819753throat
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throne98517603throne
thrones105715843thrones_
throng10539973throng
through141647523through
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thrushes1436523thrushes
thrusts10226523thrusts
thuds95110133thuds_
thugs95611993thugs_
thurls9418713thurls_
thus76721473th_us_
thymes144810743thymes_
thyrse1235133thyrse
thyrses1335023thyrses
thyrsi1234453thyrsi
tides64830153tides_
tiers55526523tiers_
ties45248313t_ies_
tigress836093tigress
tigrish1137573tigrish
tikes95628903tikes_
tiles55542103tiles_
times75630823times_
tines54848423tines_
tire46143353tire__
tired65228903tire_d
tirls54519803tirls_
tiros54524893tiros_
titres64718933titres_
toes46956443t_oes_
tokes95234973tokes_
toles55147133toles_
tomes76037383tomes_
tones56048663tones_
tonish93415903tonish
topes76941763topes_
torah87125273tor_ah
torahs95115643torahs
toras55540373toras_
torch107420933tor_ch
torcs75123763torcs_
tore47359323tore__
torero6313203torero
tories65435883tories_
toros54336193toros_
torose64317693torose
toroth95512963toroth
torrs53923563torrs_
tors46157383tor_s_
torse55833333tor_se
torses64727953torses
torsi57423363tor_si
torsk94915773tor_sk
torso56922143tor_so
tortes64826053tortes_
torts56138123torts_
torus54329763torus_
tosh74826813t__osh
totes55139683totes_
toyish122911123toyish
trashy12509053t_rashy
trass56226473t_rass
tread64821703t_read
treat56240353t_reat
tree47745813t_re_e
treed65626733t_reed
treen55622753t_reen
trees55835763t_rees
tref77030993t_re_f
trefah1235093t_refah
trek86222313t_re_k
treks96016853t_reks
trench114211613t_rench
trend64817453t_rend
tressy9448553t_ressy
tret46653533t_re_t
trets55928023t_rets
trews86118893t_rews
trey77228793t_re_y
treys85018213t_reys
tries55742813tries_
troth85622203t_roth
trues54925323trues_
truest64816193truest
truss54916923t_russ
trust55426853t_rust
truth85214153t_ruth
tryst84716223t_ryst
tsores65113663tsores_
tubes74826453tubes_
tules54532793tules_
tunes55332193tunes_
turbeth1274713turbeth
turds65021693turds_
tureen63312723tureen
turfs84620443turfs_
turks95320823turks_
turns55623243turns_
turpeth1284813turpeth
turps74918733turps_
turves94212693turves_
tush74523903t__ush
tusseh9448423tusseh
tuxes124316043tuxes_
twaes86513663twaes_
tyees86019453tyees_
tyers86220053tyers_
tyes76433373t_yes_
tykes125817063tykes_
tynes85920303tynes_
types105721063types_
tyre75428253tyre__
tyred95816433tyre_d
tyros85118593tyros_
unmesh1145793unmesh
unrest62918853unrest
uprush1135783uprush
vires84529683vires_
wares88250583wares_
wheres125917433wheres_
whish144512923wh_ish
whoosh15244353whoosh
whores125617103whores_
whorish1636603whorish
wires86034913wires_
wrest84925433_wrest
yarest95018913yarest
yores85031323yores_

Search took 6 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.376475242.0
2DLD Change Limit1127164434.68624053.8
3Display Results4434430.1403164.3
 (SQL Overall)1786914435.20234350.4
 
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.