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

452 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
threat9502046(None) 
thereat104315241thereat
thread105011091thread
threap11569661threap
threats104311671threats
throat94819751throat
treat56240351t_reat
cheat105732452ch_eat
great66034242_great
heat77061422_h_eat
hereat93527412hereat
phreak1536152phreak
teat45963632t__eat
that75639322th__at
theft114118132th_eft
theta83414572th_eta
thraw1110515922thr_aw
threads11419952threads
thready14435902thready
threaps12488642threaps
threated1259202threated
threaten1146302threaten
three87526912thre_e
threep115910112threep
threes97117322threes
thresh12276862thresh
threw1117315712thre_w
thrift12412042thrift
throats104612192throats
throaty13428482throaty
thrust91911892thrust
tread64821702t_read
treats64821692t_reats
treaty94414352t_reaty
tret46653532t_re_t
wheat114924572wh_eat
whereat134311922whereat
abreact11310823abreact
abreast9311273abreast
afreet9315153afreet
ahead96817053ah_ead
airest63825263airest
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
arhat8327093_arhat
arrear6310253arrear
arrest63722633arrest
aureate72515283aureate
barest85327693barest
beat66168303__beat
bereft114317303bereft
beret74946363bere_t
bleat75737003_bleat
boreal84817213boreal
boreas85421733boreas
brat66055543_br_at
bread85523113_bread
break115319403_break
bream95121813_bream
breast8319633_breast
breath113916263_breath
brent75734133_brent
bureau8712523bureau
buret77444013bure_t
carat75048793car_at
caret75360563care_t
caveat11417723caveat
cereal8315833cereal
chaeta11310683chaeta
chat95546133ch__at
cheap126915943ch_eap
cheats114519543ch_eats
chert105232103ch_ert
chest104926143ch_est
chorea115216083chorea_
choreal124412223choreal
choreas124414203choreas
cleat76335063_cleat
creak115418433_creak
cream95721353_cream
create85126383_create
crept95125893_crept
crest74632693_crest
curet75447643cure_t
defeat103817163defeat
derat65044083der_at
direct93817333direct
direst75024243direst
drat56247833_dr_at
dread74419023_dread
dream85120393_dream
dreamt94615713_dreamt
drear65016903_drear
drest65530343_drest
eat36989053___eat
egret63327313egre_t
entreat7315263entreat
erect74129333_erect
estreat7314813estreat
ethereal1146783ethereal
feat76458223__feat
forest94926743forest
forgat104018583forgat
format113021353format
frat75648543_fr_at
freak125115243_freak
fret75845043_fre_t
gerent73223093gerent
ghat86435283gh__at
gherao1036753gherao
grat55651283_gr_at
greats76318393_greats
greet65835323_greet
groat65531973_groat
haet75659503_hae_t
hat67289963_h__at
head87137173_h_ead
heal75645693_h_eal
heap96432893_h_eap
hear76143883_h_ear
heart85440743_h_eart
heath115724283_h_eath
heats85838403_h_eats
heft106736293_h_eft
hent76656383_h_ent
hest75950773_h_est
het67674313_h_e_t
ihram10310183ihr_am
intreat7416303intreat
irreal657833irreal
jurat124829323jur_at
karat96837593kar_at
khat116730723kh__at
khet116328623kh_e_t
korat94934433kor_at
lariat6629043lariat
loreal63814313loreal
meat66359603__meat
merest84725113merest
miseat82925703miseat
neat46356783__neat
ochrea11316643ochrea_
ochreae12295083ochreae
ocrea73311823ocrea_
ocreae83310273ocreae
ocreate93711743ocreate
oread64619603_oread
orgeat7515033orgeat
outeat62824533outeat
overeat102620323overeat
parent83230423parent
peat65967933__peat
perea75026443perea_
phat95837863ph__at
phreaks1634543phreaks
phreatic1548343phreatic
pleat74734473_pleat
prat65952043_pr_at
preact103220393_preact
prest75736353_prest
purest84021933purest
rarest65725483rarest
rat37892743__r_at
react74634333__react
read55942533__read
real45750293__real
ream65841613__ream
reap65934743__reap
rear45644553__rear
reata54225393__reata
reft75141273__reft
reheat94423943reheat
rent46661243__rent
repeat85127213repeat
reread71715433reread
rerent63832453rerent
resat55139683__resat
reseat64131493reseat
rest46459843__rest
ret35982833__re_t
rethread1245353rethread
retreat7317533retreat
rhea75017433rh_ea_
rheas84816953rh_eas
screak125311063screak
scream104814253scream
seat47575563__seat
serest64831613serest
shat76456603sh__at
shea76031573sh_ea_
sheaf115424123sh_eaf
sheal84927703sh_eal
shear85424833sh_ear
sheas86331793sh_eas
sheath12412893sh_eath
sheet84836963sh_eet
shent85933503sh_ent
shiest95821523shiest
shmear1176933shmear
shoat85633953sh_oat
shred98125613shre_d
shreds105613053shreds
shrew119720173shre_w
shrewd136810783shrewd
shrews129313923shrews
shrift12413543shrift
shyest125511833shyest
sorest65028003sorest
sprat76635973spr_at
spread9312533spread
sprent84522383sprent
streak104613623streak
stream84717293stream
street64125773street
surest65026763surest
sweat85628403_sweat
tacet75840023tace_t
talent6323323talent
tamest85721293tamest
tapeta8310693tapeta
tare45957623tare__
tared69340053tare_d
tares57456563tare_s
target75028903target
tarmac10310333tarmac
tarnal63716503tarnal
tarot55943933tar_ot
tarpan82814293tarpan
tarsal63315273tarsal
tart47566183tar__t
tartan64217513tartan
tartar63214753tartar
tartest72517533tartest
tarzan152910753tarzan
tat37690293t___at
tea37353323t__ea_
teak85930843t__eak
teal45546503t__eal
team66238653t__eam
tear45242883t__ear
teas45851493t__eas
teats55636813t__eats
tenet55542213tene_t
tent46159863t__ent
terai53525483ter_ai
tercet83624913tercet
teredo7310783teredo
terefah1344113terefah
terete6319333terete
terga63315643terga_
tergal72912833tergal
ternate7415483ternate
terra54419663terra_
terrae62915213terrae
terras63516973terras
terret63425623terret
territ63421373territ
tersest71713993tersest
test48651623t__est
tet39274993t__e_t
text116033933t__ext
thae76825563th__ae
than76128773th__an
thaw107521313th__aw
the67436053th_e__
theater104014253th_eater
theatre10358493th_eatre
thebe107515433th_ebe
theca103311453th_eca
thecae11299653thecae
thecal113310303thecal
thecate123210023thecate
thee78039063th_e_e
thefts12387923th_efts
thegn95810903th_egn
thein85919023th_ein
their85512153th_eir
theist9314763theist
them97427043th_e_m
theme105921733th_eme
then78429693th_e_n
thenal92712423thenal
thenar92610003thenar
thens85921833th_ens
therapy1536613therapy
there87527393th_ere
thereby1534633thereby
therein102310353therein
thereof13168063thereof
thereon10199263thereon
theres96525473theres
thereto1038993thereto
theriac1239143theriac
therian10311293therian
therm106018023th_erm
thermae125310503thermae
thermal125010973thermal
therme115814993therme
thermit12312013thermit
therms115914873therms
these86519013th_ese
thesp105410313th_esp
thetas93011573thetas
thew108226233th_e_w
thews117416193th_ews
thewy146311853th_ewy
they107223753th_e_y
thief114516303thie_f
thieve1235963thieve
thiram1139963thiram
thirst9312253thirst
thorax1638253thorax
thoria93012893thoria_
thorias102312053thorias
thrall93810293thrall
thrash12258363thrash
thrave126010273thrave
thrawart1445163thrawart
thrawn12769423thrawn
thraws129211103thraws
threaded1366323threaded
threader1256733threader
threaped1454863threaped
threaper1345143threaper
threatens1254673threatens
threating131010053threating
threeps12687043threeps
thrice114311573thrice
thrifts1335523thrifts
thrifty1634193thrifty
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrive125313223thrive
thro77726423thr__o
throated1247923throated
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thruput1243863thruput
thrush12257483thrush
thrusts10226523thrusts
thruway1643163thruway
thuja1535213thuja_
thujas1634433thujas
thuya1135583thuya_
thuyas1234773thuyas
thwart12311683thwart
tinea54923163tinea_
tineal66216163tineal
tineas64616483tineas
tipcat10312653tipcat
tire46143353tire__
tired65228903tire_d
tires55437493tire_s
toea46732333t_oea_
toeas55726423t_oeas
tomcat101013453tomcat
tora47545993tor_a_
torah87125273tor_ah
toras55540373tor_as
tore47359323tore__
torero6313203torero
tores55352673tore_s
torment9316173torment
torot56139943tor_ot
torrent7313413torrent
tort46967463tor__t
torta55925353torta_
tortas64918253tortas
tract75635713t_ract
trad55630913t_r_ad
trait56940843t_rait
tram67034553t_r_am
trap67532803t_r_ap
trapt76433393t_rapt
tray77632593t_r_ay
treads74817923t_reads
treated83618703t_reated
treater74219833t_reater
tree47745813t_re_e
treed65626733t_reed
treen55622753t_reen
trees55835763t_rees
tref77030993t_re_f
trefah1235093t_refah
trek86222313t_re_k
treks96016853t_reks
trend64817453t_rend
trepan82511673t_repan
tres46542903t_re_s
tress55423163t_ress
trets55928023t_rets
trevet94818913t_revet
trews86118893t_rews
trey77228793t_re_y
treys85018213t_reys
triac74116373t_riac
triad65217723t_riad
trial54926353t_rial
troak95213573t_roak
trot46351313t_r_ot
trout57332573t_rout
truant6315783t_ruant
truest64816193truest
trust55426853t_rust
tryst84716223t_ryst
turban8310483turban
turbit8715113turbit
turbot8914263turbot
tureen63312723tureen
turgent8712393turgent
turret63121853turret
twat75831513t__wat
tweak1257753t_weak
tweet84823983t_weet
tyrant9315333tyrant
tyre75428253tyre__
tyred95816433tyre_d
tyres84725233tyre_s
unread73412673unread
unreal64414453unreal
unrent63219783unrent
unrest62918853unrest
unseat64221023unseat
unthread1244603unthread
upbeat10911513upbeat
uprear8168793uprear
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
what105434073wh__at
wheal115716183wh_eal
wheats125013223wh_eats
whereas13448903whereas
whet105133783wh_e_t
wreak125513273_wreak
wreath124111193_wreath
wrest84925433_wrest
yarest95018913yarest

Search took 9 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.780229091.0
2DLD Change Limit1127164527.94014196.0
3Display Results4524520.1403228.6
 (SQL Overall)1786914528.86020168.3
 
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.