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

353 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
threats10431167(None) 
threads11419951threads
threaps12488641threaps
threat95020461threat_
throats104612181throats
treats64821691t_reats
cheats114519542ch_eats
greats76318392_greats
heats85838402_h_eats
phreaks1634542phreaks
teats55636812t__eats
thefts12387922th_efts
thereat104315242thereat_
thetas93011572th_etas
thraws129211102thr_aws
thread105011092threa_d
thready14435902thready
threap11569662threa_p
threated1259202threated
threaten1146302threaten
threatens1254662threatens
threeps12687042threeps
threes97117322thre_es
thrifts1335522thrifts
throat94819752throat_
throaty13428482throaty
thrusts10226522thrusts
treads74817922t_reads
treat56240352t_reat_
treaty94414352t_reaty
trets55928022t_re_ts
wheats125013222wh_eats
abreacts1245633abreacts
abreast9311273abreast
afreets1037013afreets
areas55935773_area_s
arhats9312973_arhats
arrears738843arrears
arrests73312683arrests
aureate72515283aureate
beats76042243__beats
berets85822523bere_ts
bleats85518613_bleats
boreas85421733borea_s
brats75336013_br_ats
breads95419203_breads
breaks124816423_breaks
breams104815043_breams
breast8319633_breast
breasts939703_breasts
breath113916263_breath
breaths124411183_breaths
brents84717273_brents
bureaus979283bureaus
burets84321263bure_ts
carats85929023car_ats
carets85330773care_ts
caveats1239803caveats
cereals9313173cereals
chats105730093ch__ats
cheaps134613683ch_eaps
cheat105732453ch_eat_
cherts115617233ch_erts
chests114916263ch_ests
choreas124414203chorea_s
cleats84919313_cleats
creaks124315963_creaks
creams104715253_creams
create85126373_create
creates95225193_creates
crests85218703_crests
curets84922343cure_ts
defeats113511233defeats
derats74625063der_ats
directs102710263directs
drats66628373_dr_ats
dreads84115023_dreads
dreams94513983_dreams
drears74614253_drears
eats47054873___eats
egrets72712243egre_ts
entreats839773entreats
erects84116183_erects
estreats839423estreats
feats86432753__feats
forests104114953forests
formats123113573formats
frats86829673_fr_ats
freaks134713063_freaks
frets85523403_fre_ts
gerents82612923gerents
ghats95818613gh__ats
great66034243_great_
greets75117423_greets
groats74816653_groats
haets86525123_hae_ts
hats76858253_h__ats
heads95127113_h_eads
heals85733453_h_eals
heaps105223223_h_eaps
hears86737373_h_ears
hearts96218943_h_earts
heat77061423_h_eat_
heath115724283_h_eath
heaths126316383_h_eaths
hefts116218153_h_efts
hents87330743_h_ents
hereat93527413hereat_
hests85829933_h_ests
hets75547203_h_e_ts
ihrams1137173ihr_ams
intreats8311543intreats
jurats134213203jur_ats
karats106420493kar_ats
khats125316013kh__ats
khets124913433kh_e_ts
korats105416063kor_ats
lariats7615053lariats
meats75034053__meats
miseats92815783miseats
neats55931903__neats
ocreate93711743ocreate
oreads73915773_oreads
orgeats838353orgeats
outeats72215703outeats
overeats112415263overeats
parents93418123parents
peats76140193__peats
phreak1536153phrea_k
phreatic1548343phreatic
pleats85218593_pleats
prats76333393_pr_ats
preacts113211363_preacts
prests84021263_prests
rats46260373__r_ats
reacts83616603__reacts
reads64835273__reads
reals55038653__reals
reams75729623__reams
reaps75626193__reaps
rears54739653__rears
reata54225393__reata
reatas64021013__reatas
reheats104513523reheats
rents55935183__rents
repeats94316053repeats
rereads81512293rereads
rerents73319423rerents
reseats74319583reseats
rests54935873__rests
rethreads1344483rethreads
retreats8311413retreats
rets45352563__re_ts
rheas84816953rh_ea_s
screaks13469353screaks
screams114810613screams
seats54844343__seats
sheafs124912883sh_eafs
sheals94420643sh_eals
shears93820903sh_ears
sheas86331793sh_ea_s
sheath12412883sh_eath
sheaths1358743sh_eaths
sheets93918493sh_eets
shmears1277073shmears
shoats94117073sh_oats
shreds105613053shre_ds
shrews129313913shre_ws
shrifts1335963shrifts
sprats85819933spr_ats
spreads1039763spreads
starets73515923stare_ts
streaks114411273streaks
streams94713373streams
streets73312613streets
sweats94814613_sweats
talents7312013talents
tares57456563tare__s
targets84314223targets
tarmacs1138323tarmacs
tarots66422993tar_ots
tarpans92513533tarpans
tarsals72512603tarsals
tartans72615823tartans
tartars73313403tartars
tarts57242023tar__ts
tarzans16329923tarzans
tats46858133t___ats
teaks94222903t__eaks
teals56234133t__eals
teams75726513t__eams
tears55436463t__ears
teas45851493t__ea_s
teat45963633t__eat_
tenets65518953tene_ts
tents56434213t__ents
terais64023503ter_ais
tercets93512443tercets
teredos839173teredos
terete6319333tere_te
ternate7415483ternate
terras63516963terra_s
terrets72913573terrets
territs72714493territs
tests56530193t__ests
tets45847453t__e_ts
texts125515043t__exts
thanatos1165123thanatos
that75639323th__at_
thaws116515463th__aws
theater104014253th_eater
theaters114211903th_eaters
theatre10358493th_eatre
theatres11298633th_eatres
thebes115914493th_ebes
thecate123210023thecate
theft114118133th_eft_
thegns10547433th_egns
theins95015423th_eins
theirs94610353th_eirs
theist9314763th_eist
theists1039153theists
themes115319253th_emes
thenars10248523thenars
thens85921833th_e_ns
therapy1536613therapy
theres96525473th_eres
thereto1038993thereto
theriacs1336543theriacs
therians1138313therians
thermals13518533thermals
thermes126214613thermes
thermits1338513thermits
thermos124610753thermos
therms115914873th_erms
theses96517973th_eses
thesis94913733th_esis
thesps11448263th_esps
theta83414573th_e_ta
thews117416193th_e_ws
thieves1346903thieves
thirams1236823thirams
thirsts1036243thirsts
thorias102312053thoria_s
thrall93810293thr_all
thralls10299043thralls
thrash12258363thr_ash
thrave126010273thr_ave
thraves13469713thraves
thraw1110515923thr_a_w
thrawn12769423thr_awn
threaded1366323threaded
threader1256733threader
threaders1365743threaders
threaped1454863threaped
threaper1345143threaper
threapers1444773threapers
threating131010043threating
three87526913thre__e
threep115910113thre_ep
thresh12276863thre_sh
threshes1437383threshes
threw1117315713thre__w
thrift12412043thrift_
thrifty1634193thrifty
thrills10398783thrills
thrips11299013thr_ips
thrives134611713thrives
throated1247923throated
throbs118311373thr_obs
throes97518673thr_oes
thrones105715843thrones
throngs11508163throngs
throws129715233thr_ows
thrums11429123thr_ums
thruputs1341963thruputs
thrust91911893thrust_
thruways1742503thruways
thujas1634433thuja_s
thuyas1234773thuya_s
thwarts1345023thwarts
tineas64616483tinea_s
tipcats1137103tipcats
tires55437493tire__s
toeas55726423t_oea_s
tomcats11127773tomcats
torahs95115643tor_ahs
toras55540373tor_a_s
toreros7311343toreros
tores55352673tore__s
torments10310453torments
torrents838143torrents
tortas64918253torta_s
torts56138123tor__ts
tracts85019073t_racts
traits65121983t_raits
trams75327673t_r_ams
trans54933043t_r_ans
traps75727483t_r_aps
trass56226473t_r_ass
trays85623433t_r_ays
tread64821703t_rea_d
treated83618703t_reated
treater74219833t_reater
treaters83615843t_reaters
treaties8316983t_reaties
treatise8311103t_reatise
treens65317873t_reens
trees55835763t_re_es
treks96016853t_re_ks
trends75513543t_rends
trepans92311593t_repans
tres46542903t_re__s
tress55423163t_re_ss
tret46653533t_re_t_
trevets10499973t_revets
trews86118893t_re_ws
treys85018213t_re_ys
triacs83913223t_riacs
triads74513533t_riads
trials64319883t_rials
troaks104410603t_roaks
trots56629943t_r_ots
trouts66116633t_routs
truants738163t_ruants
trusts64714433t_rusts
trysts9448793t_rysts
turbans939563turbans
turbits969233turbits
turbots988023turbots
tureens7289873tureens
turrets73010673turrets
twats86616603t__wats
tweaks1335963t_weaks
tweets94210103t_weets
tyrants1037453tyrants
tyres84725233tyre__s
unrests7229463unrests
unseats73012853unseats
unthreads1343633unthreads
upbeats1195733upbeats
uprears9107493uprears
ureas55826013_urea_s
whats117718993wh__ats
wheals124512523wh_eals
wheat114924573wh_eat_
whereas13448903wherea_s
whereat134311923whereat_
whets115019613wh_e_ts
wreaks134711113_wreaks
wreath124111193_wreath
wreaths13338373_wreaths
wrests95313083_wrests

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 Filter1786911340270.310576422.6
2DLD Change Limit1340273538.37616001.3
3Display Results3533530.1402521.4
 (SQL Overall)1786913538.82620246.0
 
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.