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

544 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
roasting9301270(None) 
boasting113512501boasting
coasting113615511coasting
roosting93411461roosting
rousting93913271rousting
toasting93410581toasting
basting104227202_basting
blasting114013432blasting
boating103721302boa_ting
boosting113311052boosting
breasting1239582breasting
casting104628342_casting
coacting133412702coacting
coapting133511612coapting
coastings12357862coastings
coating103525312coa_ting
costing104323022co_sting
doating93816862doa_ting
easting84924302_easting
fasting114522832_fasting
feasting122011322feasting
foisting122910502foisting
frosting12311182fro_sting
frowsting1634682frowsting
gasting95022762_gasting
hasting114725192_hasting
hoisting123610902hoisting
hosting114318382ho_sting
joisting16328502joisting
jousting16309352jousting
lasting84725242_lasting
masting104325822_masting
moating104218152moa_ting
orating83520322ora_ting
ousting84021352_ousting
pasting103826552_pasting
posting105622242po_sting
rafting113815752r_afting
ranting84025412r_anting
rasing74330832r_as_ing
rasping104316252r_asping
rating74938702r_a_ting
ratting83822362r_atting
reacting113317892reacting
recasting122414232recasting
reesting93118272reesting
repasting122312842repasting
resting85031182r_esting
retasting102513412retasting
roaching143210432roaching
roaming103215792roa_ming
roaring82916002roa_ring
roosing84018132roos_ing
rooting83522432ro_oting
rosing73925592ro_s_ing
rotating92614552rotating
rotting82919682ro_tting
rousing83920552rous_ing
routing83821092ro_uting
rusting83821262r_usting
tasting84624212_tasting
wasting114422842_wasting
worsting1267682worsting
yeasting12188922yeasting
abashing1466623abashing
abasing10610673abas_ing
abating10413973aba_ting
acting95920983__acting
adapting1236643adapting
agisting1038243agisting
amassing1138003amassing
anting75827023__anting
arointing1049363arointing
arousing93811803arous_ing
aroynting1344633aroynting
arresting1038633arresting
ashing107824093__ashing
asking116017233__asking
awaiting1238273awaiting
baiting103918883_baiting
bashing135422583_bashing
basing95427663_bas_ing
basking144718613_basking
bastings114214693_bastings
bating95132253_ba_ting
batting104422273_batting
beastings12387653beastings
beating104326873bea_ting
besting104923923_besting
biasing103512453bias_ing
biassing11307263biassing
blastings12347913blastings
blatting114111653blatting
bloating113512813bloa_ting
boarding123110233boarding
boatings113710113boa_tings
bogarting1334653bogarting
bolting104416763bo_lting
booting103821363bo_oting
borating113414503borating
bossing103714603bo_ssing
bousing103718043bous_ing
bowsing134012503bows_ing
bowstring15165123bowstring
brassing112612303brassing
broaching17287663broaching
bromating1439173bromating
browsing14319353brows_ing
bursting1138703bursting
busting104221793_busting
canting104725903_canting
carting104228283_carting
cashing135022553_cashing
casing94829103_cas_ing
casking144317353_casking
castings113614053_castings
castling11311233_castling
catting103922643_catting
ceasing104118263ceas_ing
chanting143413533chanting
charting142614193charting
chasing133715893chas_ing
chatting142810143chatting
clashing143812193clashing
clasping133310263clasping
classing113211793classing
coaching164011963coaching
coaling103722823coa_ling
coaming123818323coa_ming
coastline1196363coastline
coatings113811843coa_tings
coaxing173511703coa_xing
cohosting1546323cohosting
compting153013603compting
coopting133411313coopting
corseting12312173corseting
coshing134316433co_shing
cosseting1239543cosseting
cosying134513133co_sying
coting94629253co__ting
counting113115273counting
courting112514573courting
coveting141912303coveting
crafting143710173crafting
crashing143512633crashing
crating103725203cra_ting
creasing113314443creas_ing
creating113921953crea_ting
cresting114017043cresting
croaking153712163croa_king
crossing112612683cro_ssing
crostini1038293cro_stini
crostino1038883cro_stino
crusting113612793crusting
darting94020663_darting
dashing125917893_dashing
dating85326483_da_ting
dauting93814763_dauting
dawting123610673_dawting
deashing134210953deashing
demasting1338453demasting
donating10311803donating
dosing83920273do_s_ing
dossing93313273do_ssing
doting84821913do__ting
dotting93314483do_tting
doubting1237373doubting
dousing93315763dous_ing
dowsing123411123dows_ing
drafting13339403drafting
dratting10389653dratting
drowsing13287773drows_ing
dusting93618993_dusting
easing74926463_eas_ing
eastings93412953_eastings
eating75134403_ea_ting
egesting1039013egesting
elastin72611843elastin_
elastins82111743elastins
elating83423083ela_ting
enacting11311363enacting
erasing8317963eras_ing
exacting1838523exacting
exalting1638033exalting
existing1639073existing
farting114120753_farting
fashing144918793_fashing
fastings124011943_fastings
fating105328673_fa_ting
fatting113818703_fatting
feasing113916653feas_ing
fisting113818123_fisting
flashing153711553flashing
flatting123511253flatting
floating123111883floa_ting
foaling113515843foa_ling
foaming133612993foa_ming
footing115017593fo_oting
foresting13311363foresting
fronting12310443fro_nting
frostings1335733fro_stings
gaiting93716583_gaiting
gashing125119233_gashing
gasking134415913_gasking
gasping113714363_gasping
gassing94216333_gassing
gating84826953_ga_ting
ghosting1336463ghosting
glassing10329973glassing
gloating102611463gloa_ting
gnashing1336423gnashing
goading103112853goa_ding
goaling93515333goa_ling
goosing93314083goos_ing
gosling93312403go_sling
grafting13319623grafting
granting103514523granting
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
greasing102811393greas_ing
groaning102410283groa_ning
grossing103111063gro_ssing
grousing103410453grous_ing
grouting103410793gro_uting
guesting1058463guesting
gusting93917163_gusting
hafting144014173_hafting
halting114419073_halting
hanting114124483_hanting
hashing145020163_hashing
hasping134414903_hasping
hating104929713_ha_ting
hatting113920233_hatting
hearting12513123hearting
heating114024323hea_ting
heisting123411043heisting
histing113720373_histing
hoarding13288643hoarding
hoaxing18307763hoa_xing
hoising113414413hois_ing
hooting113919883ho_oting
horsing113215583hors_ing
hosing103421103ho_s_ing
hotting113116523ho_tting
housing113316523hous_ing
impasting1436323impasting
iodating1038823iodating
jesting154317713_jesting
jointing16248613jointing
jolting153410913jo_lting
joshing18519413jo_shing
jostling16207123jo_stling
jotting152912773jo_tting
justing153615163_justing
karting123716063_karting
lashing114422893_lashing
lasing74727983_las_ing
lastings94214423_lastings
leashing123310313leashing
leasing83920163leas_ing
listing84020593_listing
loading94114613loa_ding
loafing11319793loa_fing
loaming103613733loa_ming
loaning83614833loa_ning
loathing1247673loathing
locating11311503locating
lofting113311313lo_fting
loosing83515963loos_ing
looting83019643lo_oting
losing74022873lo_s_ing
lotting82917753lo_tting
lousing83817733lous_ing
louting83719383lo_uting
lusting83619323_lusting
malting103219083_malting
marting103325013_marting
mashing134422243_mashing
masking145116613_masking
massing104318023_massing
mating94832913_ma_ting
matting103620143_matting
misting103623383_misting
moaning103714443moa_ning
molesting1237753molesting
molting103517173mo_lting
mooting103019363mo_oting
moshing134214883mo_shing
mossing103915423mo_ssing
moulting112710313moulting
mounting112711813mounting
mousing103816273mous_ing
moussing1138143moussing
musting103221073_musting
nesting84320443_nesting
noising83615173nois_ing
nonacting1238783nonacting
noosing83315053noos_ing
noshing114612773no_shing
nosing73419843no_s_ing
notating92513343notating
noting74120153no__ting
oaring74225303_oa_ring
opting94514403_o_pting
orbiting1138153orbiting
orgasming1343113orgasming
outing74128153_o_uting
outsing83320463_outsing
panting104025423_panting
parting103527383_parting
pashing135120513_pashing
passing104318423_passing
pastina93914593_pastina
patting103722343_patting
phasing133211673phas_ing
plaiting113113513plaiting
planting113515383planting
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
poaching163510833poaching
pointing112813683pointing
poising103617103pois_ing
porting103021783po_rting
posing93922643po_s_ing
positing11312303positing
postin83521033po_stin_
postings112912303po_stings
postins93721203po_stins
potting103720893po_tting
pouting103519943po_uting
prating103424453pra_ting
preacting142412533preacting
precasting15169833precasting
prepasting15168883prepasting
pretasting13239283pretasting
priesting1239483priesting
probating14311193probating
profiting1549983profiting
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
prorating12314283prorating
prosing103319383pro_s_ing
protesting131910253protesting
quanting1849233quanting
quashing2137093quashing
questing1838273questing
racing95030533r_a_cing
racking144323663r_acking
radding103715003r_adding
ragging103516683r_agging
raging85126433r_a_ging
raiding93617593r_aiding
railing83325643r_ailing
raining83922693r_aining
raising83220533r_aising
raking114728423r_a_king
ramming123115063r_amming
ramping123316873r_amping
ranging94120263r_anging
ranking124320883r_anking
raping94829853r_a_ping
rapping123619103r_apping
raring74332873r_a_ring
raspings11337853r_aspings
rassling939013rassling
ratine65131823r_a_tine
ratings84217413r_a_tings
rattling92510873r_attling
raving105128853r_a_ving
raxing144321023r_a_xing
raying105027193r_a_ying
razing164524543r_a_zing
razzing1636323r_azzing
reaching143317203reaching
readding11411363readding
reading93327213rea_ding
readying13410223readying
reaming103924013rea_ming
reaping103621213rea_ping
rearing83128783rea_ring
rearming111413613rearming
reasoning10310203reasoning
reassign955423reassign
reaving113820533rea_ving
rebaiting12311643rebaiting
rebating112418343rebating
recanting122414823recanting
reciting113118073reciting
recoating121317463recoa_ting
redacting13612303redacting
redating102620173redating
refuting121911903refuting
rehashing1647113rehashing
relating92725443relating
relisting102414353relisting
remating112322413remating
renesting102514703renesting
renting84026853r_enting
repassing12249423repassing
reputing112412603reputing
resawing122311433resawing
resaying122512453resaying
resisting103215313resisting
resiting93521123resiting
restring91518783r_estring
retesting102614603retesting
retting83425883r_etting
reusing82516783reus_ing
revesting132814123revesting
revoting12312033revoting
rewashing1676903rewashing
riesling939013riesling
rifting113515003r_ifting
righting132610853righting
rinsing82516113rins_ing
rioting82716393r_ioting
riposting1236063riposting
rising74025883r_is_ing
risking123914243r_isking
riveting12139443riveting
roarings9248293roa_rings
roast56230143roast___
roasted83912663roast_ed
roaster74116663roast_er
roasters83615933roasters
roasts64915413roast__s
robbing123313213ro_bbing
robing93618003ro__bing
rocketing1666973rocketing
rocking143619633ro_cking
rockling15259383rockling
rodding103814533ro_dding
rodeoing1037253rodeoing
rogering10310273rogering
rogueing1054313rogueing
roguing9309563ro_guing
roiling83220453ro_iling
roistering1148583roistering
rolfing113710653ro_lfing
rolling83620413ro_lling
romancing1446043romancing
romping123113033ro_mping
roofing113814353ro_ofing
rooking123517363ro_oking
rooming104117043ro_oming
rootling9269953rootling
roping94023023ro__ping
roqueting1944603roqueting
rosin55325313ro_s_in_
rosining92411423rosining
rosins64521863ro_s_ins
rosiny94414533ro_s_iny
roughing13278343roughing
rouging93114703ro_uging
rounding102812283rounding
rouping103715793ro_uping
routine72615903ro_utine
roving103618743ro__ving
roweling122811123roweling
rowing103623303ro__wing
roystering1445413roystering
rushing113817703r_ushing
russeting1065323russeting
rustling9249983r_ustling
rutting82718043r_utting
salting84120793_salting
sashing114621473_sashing
sassing84615553_sassing
sating74735453_sa_ting
scanting113914763scanting
scarting113415263scarting
scatting113311813scatting
seating84130683sea_ting
shafting15278683shafting
skating123613853ska_ting
slanting94115093slanting
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
smarting113212453smarting
smashing143310243smashing
soaking123116613soa_king
soaping103616223soa_ping
soaring83521893soa_ring
solating9315593solating
sooting82820963so_oting
sopiting11310763sopiting
sorting83221813so_rting
sousing83517823sous_ing
spasming13227203spasming
spatting113111763spatting
starting93116173starting
stashing123511583stashing
stating83725163sta_ting
sting65330243___sting
swashing15369743swashing
swatting12309593swatting
tarting84222653_tarting
tasking124616323_tasking
tatting84019523_tatting
tauting83316383_tauting
teasing83918513teas_ing
testing86021053_testing
throating1398403throa_ting
toadying1335043toadying
toastier846893toastier
toiting83217093to_iting
tooting83019423to_oting
tossing83612563to_ssing
toting74123793to__ting
totting82816843to_tting
tousing82916993tous_ing
tousling938793tousling
touting84118453to_uting
trashing122613223trashing
treating92519613trea_ting
troaking133310973troa_king
trotting92510913tro_tting
truanting1035603truanting
trusting93411653trusting
trysting12267053trysting
twisting12427813twisting
upcasting1434823upcasting
vatting113614853_vatting
vesting114618683_vesting
vomiting1437733vomiting
voting103916033vo__ting
wafting143911663_wafting
waisting123615213waisting
waiting113618953_waiting
wanting114220173_wanting
washing145119283_washing
westing115020273_westing
whisting15329543whisting
wisting113519743_wisting
wonting113214103wo_nting
wooshing1536683wooshing
wotting112913843wo_tting
wrastling1335523wrastling
wresting123811833wresting
zesting174515333_zesting

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 Filter1786911461620.406440125.6
2DLD Change Limit1461625446.61022112.3
3Display Results5445440.2202472.7
 (SQL Overall)1786915447.23624694.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.