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

383 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
thrash1225836(None) 
thresh12276861thresh
thrush12257481thrush
trash86119761t_rash
brash106221562_brash
crash109120012_crash
harsh116418052_harsh
hash106936502_h_ash
phrase11109902phrase
rash76039932__rash
teraph11319092teraph
thrall93810292thrall
thrashed1555362thrashed
thrasher1455742thrasher
thrashes1487652thrashes
thrave126010272thrave
thraw1110515922thra_w
thrawn12769422thrawn
thraws129211102thraws
thrust91911892thrust
torah87125272tora_h
torahs95115642torahs
toras55540372toras_
trashy12509052t_rashy
trass56226472t_rass
abash106016513_abash
afresh1255503afresh
arras55626133arras_
ash67944603___ash
auras55932563auras_
awash116613163_awash
bash915240163__bash
boras75938303boras_
brach126123303_brach
bras65746453_bras_
brashy145210593_brashy
brass75428023_brass
brush105917473_brush
buras74736303buras_
calash11312433calash
carwash1536003carwash
cash96636283__cash
charas114223613charas_
chars105936643chars_
chase105127123ch_ase
chasm125518793ch_asm
cherish15310463cherish
chias104625523chias_
chiasm13449103chiasm
choush14549063choush
chrism13710673chrism
clash106219033_clash
crass76328043_crass
crush106815993_crush
curagh1236553curagh
dash87031633__dash
deash95617243_deash
duras65727733duras_
emdash12244113emdash
encash11276943encash
endash10297123endash
eras45441503_eras_
erase54925493_erase
etherish1448273etherish
eyras84715923eyras_
fash107232293__fash
flash115716213_flash
frass85321123_frass
fresh115012203_fresh
frosh115713403_frosh
garish104516923garish
gash86833023__gash
gerah9315303gera_h
gerahs1039413gerahs
ghast95621223gh_ast
girsh95310023gir_sh
gnash9449833_gnash
graph115315613_graph
grasp84814483_grasp
grass66125203_grass
gursh94512333gur_sh
gyrase10508773gyrase
hah910655223_h_a_h
hahs108333363_h_ahs
harass9313943harass
has67372653_h_as_
hasp96627293_h_asp
hast76259483_h_ast
hath105933913_h_ath
heath115724283_heath
horah117922053hora_h
horahs126313873horahs
horas86333103horas_
hush105224113_h_ush
ihram10310183ihra_m
ihrams1137173ihrams
inrush936513inrush
khaph17395963kh_aph
koras95927113koras_
kurbash1643803kurbash
lash76539653__lash
lavash12597373lavash
leash85519213_leash
liras56021983liras_
maras75443293maras_
marish114319053marish
marsh105320853mar_sh
mash96039403__mash
midrash1335423midrash
moras76438783moras_
morass84614503morass
muras75329583muras_
ogrish1039263ogrish
ohias84415573ohias_
okras94410973okras_
onrush935343onrush
orach105219233_orach
paraph13311263paraph
paras76143043paras_
parish115022353parish
pash95638133__pash
perish114619063perish
pharaoh1545033pharaoh
phase104617213ph_ase
phrasal1246163phrasal
phrased1387383phrased
phrases12711463phrases
plash104616563_plash
potash1138273potash
prase76128753_prase
quash174512163_quash
qursh174110843qur_sh
qurush1835503qurush
rah68052403__ra_h
ras37575393__ras_
rase46149983__rase
rasp66029163__rasp
rath76037663__rath
rehash1237433rehash
resh76523453__resh
rewash1237673rewash
rheas84816953rheas_
rush76628183__rush
sash77235303__sash
seraph114011163seraph
shah105627783sh_a_h
shahs115919513sh_ahs
sheas86331793sheas_
sheath12412893sheath
sheesh1237813sheesh
shrank13359123shrank
shris84221453shris_
shush113812543sh_ush
shwas116415103shwas_
slash84719683_slash
smash104814433_smash
snash84815673_snash
soras55041013soras_
splash1168823splash
squash1846833squash
stash84916973_stash
strass67117223strass
strath93216373strath
surah86823253sura_h
surahs94515543surahs
suras55336333suras_
swash116316753_swash
tach96132753t__ach
tahrs85412333tahr_s_
takas95520683takas_
talas55935893talas_
tamasha12125433tamasha
tapas74627713tapas_
tarama8412733tarama
tarbush1234173tarbush
tares57456563tares_
tarnish101611873tarnish
tarns56433953tarns_
taros55640823taros_
tarps76527123tarps_
tars46763953tar_s_
tarsal63315273tarsal
tarsi55222173tar_si
tartish101512633tartish
tarts57242023tarts_
tas38477103t__as_
task85326653t__ask
tass45640573t__ass
teach105221123t_each
tears55436463tears_
teas45851493t_eas_
tease55428713t_ease
tepas76521683tepas_
tephras1236283tephras_
terai53525483tera_i
terais64023513terais
teraohm1244783teraohm
terms75523473terms_
terns55226873terns_
terras63516973terras_
terse55026823ter_se
tetras63017623tetras_
texas126514933texas_
thack144915173th_ack
thae76825563th_a_e
than76128773th_a_n
thane86122533th_ane
thank125817803th_ank
tharm105916643th_arm
tharms115712243tharms
that75639323th_a_t
thatch1435613thatch
thaw107521313th_a_w
thaws116515463th_aws
theism1139483theism
theist9314763theist
thens85921833thens_
therapy1536613therapy
theres96525473theres_
therms115914873therms_
these86519013th_ese
thesp105410313th_esp
thetas93011573thetas_
thews117416193thews_
thigh12410123th_igh
thighs1346633thighs
thins85826333thins_
thiram1139963thira_m
thirams1236823thirams
thirds10438603thirds_
thirls95012063thirls_
thirst9312253thirst
this76027383th_is_
thorax1638253thora_x
thorias102312053thorias_
thorns95314103thorns_
thorps113610893thorps_
those85218143th_ose
though139410783though
thous86017263thous_
thralls10299043thralls
thrashers1565313thrashers
thrashing1635683thrashing
thraves13469713thraves
thrawed1435583thrawed
thread105011093thread
threads11419953threads
thready14435903thready
threap11569663threap
threaps12488643threaps
threat95020463threat
threats104311673threats
three87526913thr_ee
threep115910113threep
threes97117323threes
threshed1535643threshed
thresher1455823thresher
threshes1437383threshes
threw1117315713thr_ew
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrive125313223thrive
thro77726423thr__o
throat94819753throat
throats104612193throats
throaty13428483throaty
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throng10539973throng
through141647523through
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thrushes1436523thrushes
thrusts10226523thrusts
thuds95110133thuds_
thugs95611993thugs_
thujas1634433thujas_
thurls9418713thurls_
thus76721473th_us_
thuyas1234773thuyas_
thwack1834213thwack
thwart12311683thwart
thyrse1235133thyrse
thyrsi1234453thyrsi
tiaras6314553tiaras_
tigrish1137573tigrish
tirade7311693tirade
tires55437493tires_
tirls54519803tirls_
tiros54524893tiros_
toast55831013t_oast
toeas55726423toeas_
togas67823003togas_
tolas54532773tolas_
tonish93415903tonish
tora47545993tora__
torch107420933tor_ch
torcs75123763torcs_
tores55352673tores_
toros54336193toros_
torose64317693torose
toroth95512963toroth
torrs53923563torrs_
tors46157383tor_s_
torse55833333tor_se
torsi57423363tor_si
torsk94915773tor_sk
torso56922143tor_so
tortas64918253tortas_
torts56138123torts_
torus54329763torus_
tosh74826813t__osh
toyish122911123toyish
trace75829613t_race
track114823013t_rack
tract75635713t_ract
trad55630913t_ra_d
trade65026043t_rade
tragi64717173t_ragi
traik95418203t_raik
trail55126773t_rail
train56529113t_rain
trait56940843t_rait
tram67034553t_ra_m
tramp96319773t_ramp
trams75327673t_rams
trank96222423t_rank
tranq145416893t_ranq
trans54933043t_rans
trap67532803t_ra_p
traps75727483t_raps
trapt76433393t_rapt
trashed113514703t_rashed
trasher104416133t_rasher
trashes104119263t_rashes
trave85223033t_rave
trawl84915873t_rawl
tray77632593t_ra_y
trays85623433t_rays
tres46542903t_res_
tress55423163t_ress
troth85622203t_roth
truss54916923t_russ
trust55426853t_rust
truth85214153t_ruth
tryst84716223t_ryst
tsars56717113tsars_
tubas75119583tubas_
tufas85314383tufas_
tunas54224123tunas_
turaco839453turaco
turds65021693turds_
turfs84620443turfs_
turks95320823turks_
turns55623243turns_
turps74918733turps_
tush74523903t__ush
tussah9356233tussah
twas76824083t_was_
tyrant9315333tyrant
tyres84725233tyres_
tyros85118593tyros_
tzars144914273tzars_
unlash938793unlash
uprush1135783uprush
urase54624693_urase
varas86028193varas_
wash106033813__wash
whish144512923wh_ish
whoosh15244353whoosh
whorish1636603whorish
wrath115715873_wrath

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.373479064.3
2DLD Change Limit1127163835.29621283.2
3Display Results3833830.1103481.8
 (SQL Overall)1786913835.77930920.7
 
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.