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

520 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
fronting1231044(None) 
frosting12311181frosting
affronting1742602affronting
arointing1049362arointing
aroynting1344632aroynting
bronzing2037692bronzing
droning93013722dron_ing
fainting123312162fainting
feinting123410832feinting
flinting123412342flinting
floating123111882floating
flouting122610472flouting
fonding123815422f_onding
fontina1038632f_ontina
footing115017592f_ooting
franking164310862franking
fretting122711522fretting
fringing133010902fringing
fritting123510702fritting
frocking18309572frocking
frogging14358732frogging
frontier1147312frontier
frontline1245052frontline
fronton1037202fronton_
frontons1136502frontons
frostings1335732frostings
frothing15208532frothing
frouncing1534762frouncing
frowning15307832frowning
frowsting1634682frowsting
fruiting12229062fruiting
granting103514522granting
grouting103410792grouting
grunting10269582grunting
ironing82414012iron_ing
printing113216082printing
pronating12313762pronating
pronging123511842pronging
ranting84025412_ranting
refronting1437272refronting
renting84026852_renting
rooting83522432_rooting
rotting82919682_rotting
routing83821092_routing
trotting92510912trotting
wonting113214102_wonting
wronging13327392wronging
aborting11710253aborting
adopting1237453adopting
agenting1039383agenting
amounting1236643amounting
anointing1038623anointing
anting75827023__anting
aproning11311793apron_ing
arousing93811803arousing
atoning83514873aton_ing
bloating113512813bloating
blotting113910433blotting
blunting11319843blunting
boating103721303_boating
bolting104416763_bolting
bonding113318433_bonding
bonging113316373_bonging
boning94223293_bon_ing
bonking144116373_bonking
boosting113311053boosting
booting103821363_booting
borating113414503borating
branding122513683branding
branning112911093branning
bringing123011273bringing
brining103216473brin_ing
broiling113112013broiling
broking143514823bro_king
bromating1439153bromating
bronzings2143643bronzings
brooding122911373brooding
brooking153710703brooking
brooming132911143brooming
browning14299643browning
browsing14319353browsing
bruiting11259973bruiting
bruting102612993br_uting
bunting103718833_bunting
canting104725903_canting
chanting143413533chanting
cloning103215473clon_ing
clonking153810153clonking
clotting113110643clotting
clouting113011683clouting
coating103525303_coating
confronting1744863confronting
coning94331823_con_ing
conking143618453_conking
conning103718753_conning
coopting133411313coopting
corning103720123corn_ing
coronating13410153coronating
costing104323023_costing
coting94629253_co_ting
counting113115263counting
crafting143710173crafting
craning103620303cran_ing
cranking154613073cranking
crating103725203cr_ating
creating113921953creating
cresting114017043cresting
cringing123311383cringing
croaking153712153croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210883cropping
crossing112612683crossing
crostini1038293crostini
crostino1038883crostino
crowding15247933crowding
crowing133814763cro_wing
crowning143510033crowning
crusting113612793crusting
daunting103310403daunting
defrosting1544493defrosting
denoting10311753denoting
denting94422183_denting
dinting93520553_dinting
doating93816863_doating
donating10311803_donating
donning93512763_donning
doting84821913_do_ting
dotting93314483_dotting
drafting13339403drafting
dratting10389653dratting
drifting13338733drifting
drinking14308913drinking
drolling103510763drolling
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dro_ving
drownding1564123drownding
drowning13298363drowning
drowsing13287773drowsing
dunting93418383_dunting
emoting10313563emo_ting
enrooting10128133enrooting
erecting112415063erecting
eroding9314273ero_ding
eructing112110173eructing
erupting11218443erupting
faceting1438783faceting
fagoting1336283fagoting
fanning113615073f_anning
farting114120753f_arting
fasting114522833f_asting
fating105328673f__ating
fatting113818703f_atting
faulting12237733faulting
fawning14409133fawn_ing
feasting122011323feasting
felting113515213f_elting
fencing132411133f_encing
fending123717603f_ending
feoffing1432963feoffing
fermenting1646823fermenting
ferreting13127683ferreting
feting104417793f__eting
fetting113517873f_etting
fighting162710083fighting
fileting1239303fileting
finding124116543f_inding
fining104223213f_in_ing
finking154016603f_inking
finning113615113f_inning
fisting113818123f_isting
fitting113516563f_itting
fixating1936183fixating
flanging132710583flanging
flanking164211083flanking
flatting123511253flatting
flaunting1335043flaunting
fleeting122910323fleeting
flensing1246973flensing
flinging133310053flinging
flirting12319013flirting
fliting113514613f_liting
flitting123010883flitting
floccing16306033floccing
flocking183410873flocking
flogging14329173flogging
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
flossing12247903flossing
flouncing1533903flouncing
flouring123010143flouring
flowing143411763flo_wing
flunking16317773flunking
fluting113815093f_luting
flyting14378553f_lyting
foaling113515843f_oaling
foaming133612993f_oaming
fobbing153410273f_obbing
fogging133513733f_ogging
foiling113317653f_oiling
foining113013453f_oining
foisting122910503foisting
folding123912443f_olding
fomenting1537233fomenting
fondling13189353f_ondling
fonduing13245893f_onduing
fontinas1136853f_ontinas
fooling113117373f_ooling
footings12248833f_ootings
footling12239923footling
footnoting1442563footnoting
foozling21275723foozling
fopping153511133f_opping
foraging1358063foraging
foraying1537433foraying
forcing134013753f_orcing
fording123717033f_ording
fordoing1357293fordoing
foresting13311363foresting
forewing1539003forewing
forging124114723f_orging
forgoing1366853forgoing
forking154014843f_orking
forming133615733f_orming
fouling113315373f_ouling
founding133010783founding
fowling143713113f_owling
foxing175012433f_o_xing
fragging14329423fragging
framing133014793fr_aming
frantic12310363franti_c
frapping16348103frapping
fraying143413433fr_aying
freaking163611443freaking
freeing113713913fr_eeing
freezing21308323freezing
frenching18267753frenching
frenzying2542413frenzying
freshing152611023freshing
friending1495553friending
frigging14268953frigging
frighting1736023frighting
frilling123011493frilling
frisking16268363frisking
frizing203310873fr_izing
frizzing2064803frizzing
front85029223front___
frontage1296243frontage
frontal1038363front_al
frontals1146273frontals
fronted114011273front_ed
frontenis1243423frontenis
fronter103611583front_er
frontes104214163front_es
frontiers1254993frontiers
frontlet1147653frontlet
frontlines1345193frontlines
frontlist1246123frontlist
frontman1344303frontman
frontmen1344423frontmen
frontpage15102633frontpage
frontpaging1851023frontpaging
fronts94415793front__s
frostier1148163frostier
frostily1436693frostily
frostline1245873frostline
frostnip1342413frostnip
frugging14317053frugging
frying134511403fr__ying
funding124113663f_unding
funking154013023f_unking
funning113813613f_unning
furcating1537783furcating
garoting10510703garo_ting
garotting1136103garotting
ghosting1336463ghosting
glinting103210053glinting
gloating102611463gloating
glouting10379693glouting
gonging103713033_gonging
grafting13319623grafting
grating93923183gr_ating
greeting103112353greeting
grifting13299263grifting
grinding1139863grinding
grinning1037863grinning
gritting10309983gritting
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gro_ping
grossing103111063grossing
grounding1236083grounding
grouping12308533grouping
grousing103410453grousing
growing123512473gro_wing
growling1348163growling
gruntling1134263gruntling
hanting114124483_hanting
haunting123510053haunting
henting113719653_henting
hinting113919223_hinting
honing103421503_hon_ing
honking153414793_honking
hooting113919873_hooting
horning113015003horn_ing
hosting114318383_hosting
hotting113116513_hotting
hunting114317123_hunting
ironings9217583iron_ings
ironizing1947933ironizing
jaunting16328633jaunting
jointing16248613jointing
jolting153410913_jolting
jotting152912773_jotting
knotting13236573knotting
knouting13226793knouting
konking113510213_konking
linting83820983_linting
lofting113311313_lofting
longing93915783_longing
looting83019643_looting
lotting82917753_lotting
louting83719383_louting
lunting83817743_lunting
minting103020813_minting
moating104218153_moating
molting103517173_molting
mooning103415553moon_ing
mooting103019363_mooting
morning103215043morn_ing
mounting112711813mounting
munting103718773_munting
nooning83014853noon_ing
noting74120153_no_ting
opting94514403__opting
orating83520323or_ating
orbiting1138153orbiting
orienting1038723orienting
outing74128153__outing
ozonating1944323ozonating
painting113614423painting
panting104025423_panting
parenting12611583parenting
phonating1537813phonating
phoning13312053phon_ing
phonying1745833phonying
planting113515383planting
plonking15358563plonking
plotting113011013plotting
pointing112813683pointing
poncing122913583_poncing
ponding114317083_ponding
ponging113416153_ponging
pontine92419053_pontine
ponying133312123_ponying
poontang1143813poontang
porting103021783_porting
posting105622243_posting
potting103720893_potting
pouting103519943_pouting
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453pr_ating
prinking153212453prinking
printings12268103printings
probating14311183probating
probing123314443pro_bing
prodding13189343prodding
profiting1549983profiting
progging132610383progging
promoing13310463promoing
promoting1439913promoting
prompting1637193prompting
proofing1439313proofing
propping122811673propping
prorating12314283prorating
prosing103319383pro_sing
proving134214073pro_ving
prowling1449993prowling
pruning10311733prun_ing
punting103318443_punting
quanting1849233quanting
quoiting1836093quoiting
quoting17310043quo_ting
rafting113815753_rafting
ranging94120263_ranging
ranking124320883_ranking
rating74938703_r_ating
ratting83822363_ratting
rending93924263_rending
rerenting102617663rerenting
rerouting10311873rerouting
resting85031183_resting
retting83425883_retting
rifting113515003_rifting
ringing93521283_ringing
rinning83216743_rinning
rinsing82516113_rinsing
rioting82716393_rioting
roaming103215793_roaming
roaring82916003_roaring
roasting93012693_roasting
robbing123313213_robbing
robing93617993_ro_bing
rocking143619633_rocking
rodding103814533_rodding
roguing9309563_roguing
roiling83220453_roiling
rolfing113710653_rolfing
rolling83620413_rolling
romping123113033_romping
roofing113814353_roofing
rooking123517363_rooking
rooming104117043_rooming
roosing84018133_roosing
roosting93411453roosting
rootling9269953_rootling
roping94023023_ro_ping
rosing73925593_ro_sing
rotating92614553_rotating
rouging93114703_rouging
rounding102812283_rounding
rouping103715793_rouping
rousing83920553_rousing
rousting93913273_rousting
routine72615903_routine
roving103618743_ro_ving
rowing103623303_ro_wing
running83514593_running
rusting83821263_rusting
rutting82718043_rutting
sainting93215733sainting
scanting113914763scanting
scenting113212813scenting
sconcing1338263sconcing
scooting113012633scooting
scouting112612753scouting
shooting122812843shooting
shorting122514793shorting
shotting123012363shotting
shouting122711783shouting
shunting123610423shunting
slanting94115093slanting
slotting92612603slotting
snooting92813193snooting
snorting92613373snorting
snouting92511923snouting
sooting82820953_sooting
sorning83116813sorn_ing
sorting83221813_sorting
sponging1238823sponging
sporting112415463sporting
spotting112812083spotting
spouting113511953spouting
sprinting12310033sprinting
sprouting1236943sprouting
stinting93415743stinting
stoning83717443ston_ing
stotting92811153stotting
strunting1037873strunting
stunting92811503stunting
swotting12268473swotting
tainting93613583tainting
taunting93510933taunting
tenting84621153_tenting
throating1398383throating
thronging1435073thronging
throning1238863thron_ing
tinting84620603_tinting
toiting83217093_toiting
tonging93314513_tonging
toning74025793_ton_ing
tontine72316143_tontine
tooting83019423_tooting
toting74123793_to_ting
totting82816843_totting
touting84118453_touting
trancing112812023trancing
treating92519613treating
trending103012833trending
trining82919213trin_ing
troaking133310963troaking
trocking153612423trocking
troking123514103tro_king
trolling93212493trolling
tromping13319593tromping
trooping112710273trooping
trothing122410843trothing
trouncing1235153trouncing
trouping11249503trouping
trowing113413703tro_wing
truanting1035603truanting
trusting93411653trusting
trysting12267053trysting
unrooting1098833unrooting
uprooting1276903uprooting
urinating10310653urinating
vaunting12338753vaunting
venting114218093_venting
voting103916033_vo_ting
vrooming14287353vrooming
wanting114220173_wanting
wonning113210793_wonning
worsting1267683worsting
wotting112913843_wotting
wresting123811833wresting
wringing13279623wringing
writing113713893wr_iting
zoning162914333_zon_ing
zonking21359113_zonking
zooning172910703zoon_ing

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 Filter1786911461620.283631417.0
2DLD Change Limit1461625208.42017358.9
3Display Results5205200.2202363.6
 (SQL Overall)1786915208.92320025.9
 
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.