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

273 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
breasting123958(None) 
abreacting1544532abreacting
basting104227202b__asting
beastings12387652b_eastings
beating104326872b_ea_ting
berating113220762bera_ting
besting104923922b_e_sting
blasting114013432b_lasting
bleating113514502blea_ting
boasting113512502b_oasting
brassing112612302br_assing
breaching17269402breaching
breading123515462brea_ding
breaking153914252brea_king
breaming133612512brea_ming
breastpin1342592breastpin_
breastpins1442712breastpins
breathing15218372breathing
breveting1536262breveting
creasing113314442creas_ing
creating113921952crea_ting
cresting114017042cre_sting
easting84924302__easting
feasting122011322_feasting
greasing102811392greas_ing
preacting142412532preacting
precasting15169832precasting
prepasting15168882prepasting
pretasting13239282pretasting
reacting113317892_reacting
recasting122414232_recasting
reesting93118272_reesting
repasting122312842_repasting
resting85031182_re_sting
retasting102513412_retasting
roasting93012702_roasting
treating92519612trea_ting
wresting123811832wre_sting
yeasting12188922_yeasting
aerating92821003aera_ting
arresting1038633arresting
baiting103918883b__aiting
ballasting1345293ballasting
bashing135422583b__ashing
basing95427663b__as_ing
basking144718613b__asking
bastings114214693b__astings
bating95132253b__a_ting
batting104422273b__atting
beaching164114143b_eaching
beading113221863b_ea_ding
beaming123618803b_ea_ming
beaning103820683b_ea_ning
bearding124011943b_earding
bearing103624773b_ea_ring
beastie92412433b_easti_e
beasties102514653b_easties
beatings114113233b_ea_tings
beestings12335923b_eestings
beeswing14255763b_eeswing
belting104119133b_e_lting
bemisting1438073bemisting
beraking153612973bera_king
bereaving1537573berea_ving
betting103921403b_e_tting
biasing103512453b_ias_ing
biassing11307263b_iassing
biestings12266033bie_stings
blastings12347913b_lastings
blatting114111653b_latting
bleaching17287093bleaching
blearing113111943blea_ring
blessing1137593ble_ssing
bloating113512813bloa_ting
boating103721303b_oa_ting
bogarting1334653bogarting
boosting113311053b_oosting
borating113414503bora_ting
bracing123817613br_a_cing
bradding13268933br_adding
bragging13359333br_agging
braiding123112703br_aiding
brailing113514793br_ailing
braining113414683br_aining
braising113014563br_aising
braking143917713br_a_king
branding122513683br_anding
branning112911093br_anning
brattling1236003br_attling
braving133714613br_a_ving
bravoing1445993br_avoing
brawling143210043br_awling
braying134416313br_a_ying
brazing193715113br_a_zing
breadline1246273breadline
breakfasting2251563breakfasting
breakings16297063brea_kings
breast8319633breast___
breastbone14132633breastbone
breasted1138823breast_ed
breastfed1542693breastfed
breasts939703breast__s
breathings16234313breathings
breeching17236473breeching
breeding123411843bre_eding
breezing20368133bre_ezing
brevetting1644333brevetting
brewing133411153bre__wing
brisking15329473br_isking
brisling112410843br_isling
bristling1246663br_istling
broaching17287663broaching
bromating1439173bromating
browsing14319353brows_ing
bruising11279143bruis_ing
bruiting11259973br_uiting
brushing14359963br_ushing
bruting102612993br__uting
bursting1138703b_ursting
busting104221793b__usting
bypassing1742953bypassing
casting104628343__casting
ceasing104118263_ceas_ing
cheating144014523chea_ting
cleating113518133clea_ting
coasting113615513_coasting
crafting143710173cr_afting
crashing143512633cr_ashing
crating103725203cr_a_ting
creaking153414123crea_king
creaming133413143crea_ming
creatin93618133crea_tin_
creatine103417413crea_tine
creatins103617513crea_tins
crediting1338843crediting
creeshing1536243creeshing
cremating14312193cremating
creosoting1343793creosoting
crestings12298043cre_stings
crevassing1643533crevassing
crusting113612793cr_usting
deashing134210953_deashing
demasting1338453demasting
derating103222283dera_ting
deratting1139513deratting
drafting13339403dr_afting
dratting10389653dr_atting
dreading113712803drea_ding
dreaming124011063drea_ming
dressing102810423dre_ssing
easing74926463__eas_ing
eastings93412953__eastings
eating75134403__ea_ting
egesting1039013ege_sting
erasing8317963er_as_ing
erecting112415063ere_cting
fasting114522833__fasting
feasing113916653_feas_ing
forecasting1744473forecasting
foresting13311363fore_sting
foretasting1554423foretasting
freaking163611453frea_king
freshing152611023fre_shing
fretting122711523fre_tting
frosting12311183fr_osting
frowsting1634683frowsting
gasting95022763__gasting
grafting13319623gr_afting
granting103514523gr_anting
grasping12348833gr_asping
grassing103311973gr_assing
grating93923183gr_a_ting
greeting103112353gre_eting
guesting1058463gue_sting
hasting114725193__hasting
hearting12513123_hearting
heating114024323_hea_ting
heisting123411043_heisting
ideating10311703idea_ting
impasting1436323impasting
jesting154317713_je_sting
lasting84725243__lasting
leashing123310313_leashing
leasing83920163_leas_ing
masting104325823__masting
nesting84320443_ne_sting
obtesting1245883obte_sting
orating83520323or_a_ting
orgasming1343113orgasming
pasting103826553__pasting
pleasing112611593pleas_ing
pleating112916053plea_ting
prating103424453pr_a_ting
preaching172811163preaching
prearming14139223prearming
preassign1244573preassign
predating13514653predating
presaging1339393presaging
pressing112516443pre_ssing
pretesting131810683pretesting
prewashing1944943prewashing
priesting1239483priesting
questing1838273que_sting
rafting113815753_r_afting
ranting84025413_r_anting
rasing74330833_r_as_ing
rasping104316253_r_asping
rating74938703_r_a_ting
ratting83822363_r_atting
reaching143317203_reaching
readding11411363_readding
reading93327213_rea_ding
readying13410223_readying
reaming103924013_rea_ming
reaping103621213_rea_ping
rearing83128783_rea_ring
rearming111413613_rearming
reasoning10310203_reasoning
reassign955423_reassign
reaving113820533_rea_ving
rebaiting12311643_rebaiting
rebating112418343_rebating
recanting122414823_recanting
reciting113118073_reciting
redacting13612303_redacting
redating102620173_redating
refuting121911903_refuting
rehashing1647113_rehashing
relating92725443_relating
relisting102414353_relisting
remating112322413_remating
renesting102514703_renesting
renting84026853_re_nting
repassing12249423_repassing
reputing112412603_reputing
resawing122311433_resawing
resaying122512453_resaying
resisting103215313_resisting
resiting93521123_resiting
restring91518783_re_string
retesting102614603_retesting
retting83425883_re_tting
reusing82516783_reus_ing
revesting132814123_revesting
revoting12312033_revoting
rewashing1676903_rewashing
roosting93411463_roosting
rousting93913273_rousting
rusting83821263_r_usting
seating84130683_sea_ting
sweating123213023swea_ting
tasting84624213__tasting
teasing83918513_teas_ing
testing86021053_te_sting
threating131010053threa_ting
toasting93410583_toasting
trashing122613223tr_ashing
treading103515333trea_ding
treadling1137503treadling
treasuring1144703treasuring
truanting1035603truanting
trusting93411653tr_usting
trysting12267053tr_ysting
unresting10311133unre_sting
upcasting1434823upcasting
vesting114618683_ve_sting
wasting114422843__wasting
westing115020273_we_sting
wrastling1335523wr_astling
wreaking163010213wrea_king
wreathing16266313wreathing
wrestling1336063wre_stling
zesting174515333_ze_sting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412737.36020195.8
3Display Results2732730.1232219.5
 (SQL Overall)1786912737.90622601.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.