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

481 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
toasty950956(None) 
tasty84820311t_asty
toast55831011toast_
toasts65914991toasts
blasty115611052blasty
boast75935702boast_
boasts85017922boasts
coast75236272coast_
coasts85719142coasts
hasty115718762_hasty
nasty85717282_nasty
oast47156322_oast_
oasts56529182_oasts
pasty105725052_pasty
roast56230142roast_
roasts64915412roasts
tarty86328182t_arty
taste55127232t_aste
tatty84720182t_atty
testy85419062t_esty
toady96814342toa_dy
toasted84011922toasted
toaster74414462toaster
tootsy9437982tootsy
tost48351922to_st_
trashy12509052trashy
trusty94710112trusty
twisty12426862twisty
vasty116215922_vasty
yeasty12438692yeasty
arty77531313__arty
ashy107717353__ashy
avast85519363avast_
banty106624003_banty
bassy1012917103_bassy
bast66362413_bast_
baste74829983_baste
basts75936933_basts
batty105422243_batty
bawty135614103_bawty
beast76338643beast_
beastly1277563beastly
beasts84519723beasts
beauty115410163beauty
blast76532573blast_
blasts85116773blasts
boart78835933boart_
boarts84716873boarts
boas66150833boas__
boasted104113743boasted
boaster94616433boaster
boat66360313boa_t_
boats75635153boa_ts
bobstay1443983bobstay
bolshy1444883bolshy
boost75132473boost_
boosts86115013boosts
booty106125913bo_oty
borty105522833bo_rty
bosky145612393bo_sky
bossy105515973bo_ssy
bounty113411073bounty
bousy104917843bous_y
brashy145210593brashy
brassy11509233brassy
bratty1159683bratty
busty105621013_busty
canty105226803_canty
casky144512683_casky
cast67159903_cast_
caste75932363_caste
casts77237793_casts
catty104520413_catty
chanty145215823chanty
chasmy16468543chasmy
chaste114617393chaste
chatty14419363chatty
chesty144610503chesty
classy11379043classy
clast76030583clast_
clasts84817293clasts
coact96130583coact_
coacts105314333coacts
coaly105521593coa_ly
coapt96131533coapt_
coapts104614013coapts
coastal9411043coastal
coasted104015963coasted
coaster94219043coaster
coat67558353coa_t_
coati75624643coa_ti
coats75635003coa_ts
comity13312713comity
cosey106226713co_sey
cost68057943co_st_
costa75523733co_sta
costly114012333co_stly
costs77231143co_sts
cosy97232703co_s_y
county114313323county
crafty14478913crafty
crusty114911343crusty
dashy125612383_dashy
doat56947673doa_t_
doats65224883doa_ts
doest65829523doest_
donsy96414683dons_y
dorty96220813do_rty
dost57248353do_st_
dotty94516103do_tty
doty86128223do__ty
drafty13638933drafty
dusty96018333_dusty
dynasty1463203dynasty
east46659103_east_
easts57530323_easts
easy76224493_eas_y
fast77052313_fast_
fasts86429683_fasts
fatty115117413_fatty
fealty122910223fealty
feast85932723feast_
feasts95116093feasts
feisty12449293feisty
flashy15498173flashy
floaty124210943floa_ty
foamy135313203foa_my
foist85730973foist_
foists95413983foists
footsy12587933footsy
footy115820533fo_oty
forty114824273fo_rty
frosty124710633frosty
frowsty16464983frowsty
fusty115016523_fusty
gassy95514023_gassy
gast56052563_gast_
gasts66628633_gasts
ghast95621223ghast_
ghastly14354563ghastly
ghosty13467213ghosty
glassy10527753glassy
gnatty10336483gnatty
goas55239943goas__
goat56250833goa_t_
goats65527303goa_ts
goosey105913513goosey
goosy96018883goos_y
gorsy95915783gors_y
gouty95217363go_uty
grassy10619093grassy
gusty95119573_gusty
hast76259483_hast_
haste85927863_haste
hearty126313633hearty
hoagy124710473hoa_gy
hoary114516763hoa_ry
hoist86433213hoist_
hoists95516023hoists
honesty13378053honesty
hooty115022443ho_oty
horsey125115403horsey
horst85833513horst_
horste94817413horste
horsts95817513horsts
horsy116318393hors_y
hosey116127023ho_sey
host77852833ho_st_
hosta85917833ho_sta
hostly124210863ho_stly
hosts85526703ho_sts
janty156816963_janty
joist125125653joist_
joists134711033joists
jolty155713033jo_lty
jotty155012603jo_tty
joust125122293joust_
jousts135011273jousts
koas85635093koas__
laity85318903_laity
last46260323_last_
lastly93310873_lastly
lasts57731263_lasts
lealty92910603lealty
least56134883least_
leasts64616413leasts
loamy105913343loa_my
loath84918603loa_th
lofty115813303lo_fty
lossy85214643lo_ssy
lost47951493lo_st_
lousy84617083lous_y
loyalty13114343loyalty
lusty85417573_lusty
malty106721703_malty
mashy136016503_mashy
massy104518963_massy
mast65959963_mast_
masts77035763_masts
measly113610443measly
meaty107021313mea_ty
misty106120453_misty
moas65545343moas__
moat66352033moa_t_
moats75827643moa_ts
modesty13476983modesty
moiety1148223moiety
moist76033583moist_
moistly1236613moistly
morassy12495043morassy
mosey105922873mo_sey
mossy105217063mo_ssy
most66554203mo_st_
moste75925083mo_ste
mostly113110943mo_stly
mosts76028543mo_sts
mousey115216193mousey
mousy106716943mous_y
musty105620953_musty
natty85719143_natty
noisy86813363nois_y
nosey85619883no_sey
nosy76322893no_s_y
oaky116419953_oa_ky
oases55330983_oases
oasis56422553_oasis
oat39888263_oa_t_
oath76132153_oa_th
oats46554213_oa_ts
otalgy1035353otalgy
otoplasty1454183otoplasty
oust46747443_oust_
ousts55225703_ousts
panty105929303_panty
party106630613_party
past65959013_past_
pasta76624533_pasta
paste74932953_paste
pastry114913033_pastry
pasts75936503_pasts
patsy105717203_patsy
patty104723613_patty
paty95234563_pa_ty
peaty105725693pea_ty
pesty106421713_pesty
pigsty1235933pigsty
plashy14448873plashy
platy105021663pla_ty
poachy16388963poachy
poesy105014063poes_y
pointy114913283pointy
polity113015863polity
popsy125713403pops_y
post67953363po_st_
posts75228783po_sts
posy96028423po_s_y
potsy105815613pots_y
potty105621003po_tty
pouty107018813po_uty
raspy106511703_raspy
ratty84819593_ratty
realty92713693realty
roasted83912673roasted
roaster74116663roaster
roost55730933roost_
roosts64916323roosts
rooty86423023ro_oty
rosary92810353rosary
rosy76024873ro_s_y
roust55532063roust_
rousts617016723rousts
royalty13165113royalty
rusty85221053_rusty
salty85524383_salty
sassy85813813_sassy
scanty114014663scanty
scatty115310653scatty
shanty124715123shanty
slanty95114843slanty
slaty86523153sla_ty
smarty115013793smarty
soapy106114783soa_py
softy115414483so_fty
sonsy86416373sons_y
sooty84924843so_oty
stoas55126023stoas__
stoat57135953stoa_t_
stoats65117483stoa_ts
sty66227313___sty
swarty125812383swarty
tabby125213893t_abby
tacky145617443t_acky
tact67349033t_act_
tacts76524123t_acts
taffy145110823t_affy
talky126215683t_alky
tally84526863t_ally
tammy124013223t_ammy
tangy94519953t_angy
tansy84514943t_ansy
tanto55724953t_anto
taos45541003taos__
tardy94720463t_ardy
tarry85422513t_arry
tart47566183t_art_
tartly96014023t_artly
tarts57242023t_arts
tas38477103t_as__
task85326653t_as_k
tasks94917583t_asks
tass45640573t_as_s
tasse54821843t_asse
tasted74123973t_asted
taster64930573t_aster
tastes64126423t_astes
tastily103311643t_astily
tat37690293t_a_t_
tate44748603t_a_te
tats46858133t_a_ts
taut47048963t_aut_
tautly9499503t_autly
tauts56125513t_auts
tawny114713653t_awny
teapoy1138113teapoy
teary85124053tea_ry
teas45851493teas__
tease55428713teas_e
teased74721153teased
teasel63914983teasel
teaser65421523teaser
teases65426273teases
teat45963633tea_t_
teats55636813tea_ts
tensity1039103tensity
tenty86121603t_enty
test48651623t_est_
testa54822043t_esta
tests56530193t_ests
that75639323tha_t_
thirsty1354083thirsty
thirty12378403thirty
thistly1395963thistly
throaty13428483throa_ty
thusly1235133thusly
tipsy106010503tips_y
titty85316653t_itty
toad55830183toa__d
toads65621073toa_ds
toasters83912723toasters
toastier846893toastier
toasting93410583toasting
toby96322293to__by
tocsin8311003tocsin
today96416953to_day
toddy106812423to_ddy
tods56141843tods__
tody86327213to__dy
toeas55726423toeas__
toes46956443toes__
toffy145310283to_ffy
toft77441653to_ft_
tofts84919243to_fts
togas67823003togas__
togate74515683togate
togs57242433togs__
toit46353063to_it_
toits55327473to_its
tokay125513053to_kay
tolas54532773tolas__
tomato8313453tomato
tomboy1358213tomboy
tommy124712233to_mmy
toms68343493toms__
tonality1139793tonality
tonally10311373tonally
toney86027413to_ney
tons46553053tons__
tonsil6311873tonsil
tony75635153to__ny
toot45958883to_ot_
tooth88020183to_oth
toothy12529693toothy
toots55331873to_ots
topmast1138123topmast_
topmasts1244973topmasts
tops66248123tops__
toras55540373toras__
torchy14549533torchy
torosity1147243torosity
torot56139943torot_
toroth95512963toroth
tors46157383tors__
torse55833333tors_e
torses64727953torses
torsi57423363tors_i
torsk94915773tors_k
torsks10549123torsks
torso56922143tors_o
torsos64815733torsos
tort46967463to_rt_
torta55925353to_rta
torte55431703to_rte
torts56138123to_rts
tory75840543to__ry
tosh74826813to_s_h
toss45637973to_s_s
tossed74215223tossed
tosser64215663tosser
tosses65225393tosses
tossup875293tossup
tot38884773to__t_
totality1139373totality
totally1039893totally
tote46643673to__te
tots46654123to__ts
touchy145010503touchy
toughy135911083toughy
touristy1144513touristy
touse55430673tous_e
toused74122013toused
touses64229673touses
tousle64514653tousle
tout46753823to_ut_
touts54830393to_uts
towaway1644153towaway
towery124012093towery
towny116114493to_wny
tows78545553tows__
towy105325473to__wy
toy69655193to___y
toys78036343toys__
tract75635713tract_
tracts85019073tracts
trait56940843trait_
traits65121983traits
trampy13499253trampy
tranny94210863tranny
trapt76433393trapt_
trash86119763tras_h
trass56226473tras_s
travesty1444483travesty
tray77632593tra__y
treaty94414353treaty
tressy9448553tressy
triste63818643triste
trouty95211793trouty
trust55426853trust_
trusts64714433trusts
tryst84716223tryst_
tryste9399583tryste
trysts9448793trysts
tufty114810413t_ufty
tushy114212993t_ushy
tutty85217023t_utty
twangy13386993twangy
twanky16445773twanky
twas76824083twas__
twat75831513twa_t_
twats86616603twa_ts
twenty1236223twenty
twist86820983twist_
twists9549753twists
unhasty1344283unhasty
vast75045123_vast_
vastly12508723_vastly
vasts86423773_vasts
warty119323823_warty
washy145911843_washy
waspy135410993_waspy
wast75655853_wast_
waste86125053_waste
wastry12388773_wastry
wasts87433673_wasts
worst86330133worst_
worsts96014333worsts
wost76544363wo_st_
wristy12509703wristy
yeast85327943yeast_
yeasts96413053yeasts
zesty176512163_zesty
zooty175415353zo_oty

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.390458182.1
2DLD Change Limit1127164815.25021469.7
3Display Results4814810.1403435.7
 (SQL Overall)1786914815.78030915.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.