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

216 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
thwarts134502(None) 
thwart12311681thwart_
athwart1348682athwart_
charts115823092ch_arts
harts88441592_h_arts
hearts96218942_hearts
tarts57242022t__arts
tharms115712242th_arms
thwacks1953612thwacks
thwarted1533362thwarted
thwarter1433392thwarter
thwarters1542842thwarters
thwartly1742702thwartly
towards1138782towards
twats86616602t_wa_ts
warts814840402__warts
abwatts1233403abwatts
arts49650263___arts
awaits96411953_awaits
awards107113453_awards
bewares12313373bewares
boarts84716873_boarts
bogarts1047743bogarts
carts78946293__carts
chants115020393ch_ants
charas114223613ch_aras
chards125119733ch_ards
chares115631803ch_ares
charks155219703ch_arks
charms135218843ch_arms
charrs115219193ch_arrs
chars105936643ch_ar_s
chart105038283ch_art_
chats105730093ch_a_ts
cheats114519543chea_ts
cherts115617233ch_erts
cowards1339613cowards
darts67635733__darts
departs104310683departs
dewars105117073dewar_s
dwarfs13436273_dwarfs
farts88336843__farts
ghats95818613gh_a_ts
ghauts10447783gh_auts
haars85620473_haar_s
haets86525123_h_aets
hafts116219463_h_afts
halts85230103_h_alts
hants86335403_h_ants
hards96435653_h_ards
hares86255543_h_ares
harks126333433_h_arks
harls85634503_h_arls
harms106829013_h_arms
harps105926873_h_arps
hart76865773_h_art_
hats76858253_h_a_ts
hears86737373_hear_s
heart85440743_heart_
hearth125315213_hearth
hearths135311073_hearths
hearty126313633_hearty
heats85838403_hea_ts
hoards104912623_hoards
hoars85925553_hoar_s
hurts86922823_h_urts
imparts11298533imparts
inwards1138343inwards
jowars16369653jowar_s
karts97630113__karts
khats125316013kh_a_ts
marts77442233__marts
nonarts7311303nonarts
onwards1137173onwards
oxcarts1634313oxcarts
oxhearts1842903oxhearts
parts77743373__parts
pharos11312063ph_aros
quarts154715933_quarts
rewards114813993rewards
rewarms12439603rewarms
scarts85321493_scarts
sewars94018633sewar_s
shafts125411443sh_afts
shards104319173sh_ards
shares95236413sh_ares
sharks135019723sh_arks
sharns95516983sh_arns
sharps115516083sh_arps
shears93820903shear_s
shirts94918343sh_irts
shoats94117083shoa_ts
shorts95321743sh_orts
shwas116415103shwa__s
smarts86218003_smarts
sowars94318013sowar_s
stalwarts1243813stalwarts
starts65423123_starts
stewards1236383stewards
swards105415133_swards
swarfs125612063_swarfs
swarms116112173_swarms
swart86234643_swart_
swarth126012083_swarth
swarths13537323_swarths
swarty125812383_swarty
swats85726863_swa_ts
tabards10310383tabards
tabarets10287233tabarets
tacts76524123t__acts
talars66021683talar_s
tamaris9413593tamaris
tares57456563t__ares
tarns56433953t__arns
taros55640823t__aros
tarots66422993t__arots
tarps76527113t__arps
tars46763953t__ar_s
tart47566183t__art_
tarty86328183t__arty
tatars64619793tatar_s
tats46858133t__a_ts
tauts56125513t__auts
tawers94118603tawer_s
teacarts10116073teacarts
tears55436463t_ear_s
teats55636813t_ea_ts
teawares1148083teawares
tenants7311013tenants
thacks154311923th_acks
thairms1244453thairms
thanes94918983th_anes
thanks134313133th_anks
tharm105916643th_ar_m
that75639323th_a_t_
thawers13428483thawers
thaws116515463th_a_ws
theatre10358493theatre
theatres11298633theatres
thefts12387923th_efts
theirs94610353their_s
theists1039153theists
thenars10248523thenar_s
theres96525473th_eres
therms115914873th_erms
thirams1236823thirams
thirds10438603th_irds
thirls95012063th_irls
thirst9312253th_irst
thirsts1036243thirsts
thirty12378403th_irty
thorns95314103th_orns
thorps113610893th_orps
thralls10299043thralls
thraves13469713thraves
thrawart1445163thrawart_
thraws129211103thra_ws
threats104311673threats
thrifts1335523thrifts
throats104612193throats
thrusts10226523thrusts
thurls9418713th_urls
thwack1834213thwa_ck
thwarting1632763thwarting
thwartwise195783thwartwise
tiaras6314553t_iaras
tinwares1137913tinwares
tipcarts1244573tipcarts
toasts65914993t_oasts
tolars64817943tolar_s
torts56138123t__orts
towages1139233towages
toward10311063towar_d
towers94423673tower_s
tracts85019073t_racts
traits65121983t_raits
treats64821693trea_ts
truants738163truants
tsars56717113t_sar_s
twaes86513663t_wa_es
twains95811183t_wains
twangs10358093t_wangs
twas76824083t_wa__s
twat75831513t_wa_t_
tweets94210103t_weets
twerps11345153t_werps
twirls9478123t_wirls
twirps11415013t_wirps
twists9549753t_wists
twits86015793t_w_its
tyrants1037453tyrants
tzars144914273t_zar_s
updarts1034203updarts
upwafts1541943upwafts
upwards13135963upwards
vawards14457573vawards
wafts116920553__wafts
waits88333523__waits
wants87932213__wants
wards97734403__wards
wares88250583__wares
warks127932403__warks
warms107726853__warms
warns87231003__warns
warps107126423__warps
wars78659803__war_s
wart77866083__wart_
warty119323823__warty
wasts87433673__wasts
wats77555883__wa_ts
watts86923093__watts
wharfs1546373wh_arfs
whats117718993wh_a_ts
wheats125013223whea_ts
whorts125111433wh_orts
worts88631183__worts

Search took 8 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.403443402.0
2DLD Change Limit1340272166.64320175.7
3Display Results2162160.0633428.6
 (SQL Overall)1786912167.10925135.9
 
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.