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

339 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
frothing1520853(None) 
trothing122410841trothing
clothing14278782clothing
faithing1537152faithing
farthing1538072farthing
footing115017592foot_ing
footling12239922footling
freshing152611022freshing
fretting122711522fretting
fritting123510702fritting
frocking18309572frocking
frogging14358732frogging
fronting12310442fronting
frosting12311182frosting
frothier1435952frothier
frothily1745302frothily
frowning15307832frowning
northing12199062northing
nothing113511902_nothing
rotting82919682_rotting
soothing12269972soothing
toothing12278862toothing
trithing122811772trithing
trotting92510912trotting
worthing15178052worthing
wrathing15248922wrathing
writhing15278672writhing
airthing12297953airthing
anything1534993anything
arching136216693ar_ching
arousing93811803arousing
bathing134816243_bathing
berthing14209603berthing
betrothing1644673betrothing
birthing14338433birthing
blotching1734963blotching
blotting113910433blotting
booting103821363boot_ing
botching16359703_botching
breathing15218373breathing
broaching17287663broaching
broiling113112013broiling
broking143514823bro_king
bronzing2037693bronzing
brooding122911373brooding
brooking153710703brooking
brooming132911143brooming
brothering1646033brothering
browning14299643browning
browsing14319353browsing
brushing14359963brushing
bruting102612993brut_ing
clothings15264433clothings
clotting113110643clotting
coshing134316433_coshing
coting94629253_cot_ing
crashing143512633crashing
crating103725203crat_ing
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210893cropping
crossing112612693crossing
crouching1746383crouching
crowding15247933crowding
crowing133814763cro_wing
crowning143510033crowning
crushing143010053crushing
crutching17216073crutching
doting84821913_dot_ing
dotting93314483_dotting
dratting10389663dratting
drolling103510763drolling
droning93013723dro_ning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dro_ving
drowning13298363drowning
drowsing13287773drowsing
earthing12310333earthing
emoting10313563emot_ing
eroding9314273ero_ding
erotizing1949963erotizing
fagoting1336283fagot_ing
farthings1635233farthings
farting114120753fart_ing
fashing144918793f_ashing
fasting114522833fast_ing
fating105328673f_at_ing
fatling113815683f_atling
fatting113818703f_atting
felting113515213felt_ing
feoffing1432963feoffing
fetching17298413fetching
feting104417793f_et_ing
fetting113517873f_etting
fettling1266773fettling
fighting162710083fighting
filching1736113filching
firstling1334423firstling
fishing143913863f_ishing
fisting113818123fist_ing
fitting113516563f_itting
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
fleshing15339303fleshing
fletching18256143fletching
flitching18265343flitching
fliting113514613flit_ing
flitting123010883flitting
floating123111883floating
floccing16306033floccing
flocking183410873flocking
flogging14329173flogging
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
flossing12247903flossing
flouring123010143flouring
flouting122610473flouting
flowing143411763flo_wing
flushing15288833flushing
fluting113815093flut_ing
flyting14378553flyt_ing
foaling113515843f_oaling
foaming133612993f_oaming
fobbing153410273f_obbing
fogging133513733f_ogging
foiling113317653f_oiling
foining113013453f_oining
folding123912443f_olding
fonding123815423f_onding
fooling113117373f_ooling
foothill1444993foothill
footings12248833foot_ings
foozling21275723foozling
fopping153511133f_opping
foraging1358063foraging
foraying1537433foraying
forcing134013753f_orcing
fording123717043f_ording
fordoing1357303fordoing
forewing1539003forewing
forging124114723f_orging
forgoing1366853forgoing
forking154014843f_orking
forming133615733f_orming
fortuning1345493fortuning
fouling113315373f_ouling
fowling143713113f_owling
foxing175012433f_o_xing
fragging14329423fragging
framing133014793fr_aming
franking164310863franking
frapping16348103frapping
fraying143413433fr_aying
freaking163611453freaking
freeing113713913fr_eeing
freezing21308323freezing
frenching18267753frenching
frigging14268953frigging
frighting1736023frighting
frilling123011493frilling
fringing133010903fringing
frisking16268363frisking
frizing203310873fr_izing
frizzing2064803frizzing
frontline1245053frontline
frostings1335733frostings
frostline1245883frostline
froth115919283froth___
frothed14288783froth_ed
frother133110153froth_er
frothers14279813frothers
frothiest1537453frothiest
frothiness1645723frothiness
froths125411443froth__s
frothy15578373froth__y
frouncing1534763frouncing
frowsting1634683frowsting
frugging14317053frugging
fruiting12229063fruiting
frying134511403fr__ying
futzing20307903f_utzing
garoting10510703garot_ing
garotting1136113garotting
girthing13256083girthing
graphing1538533graphing
grating93923183grat_ing
gritting10309983gritting
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gro_ping
grossing103111063grossing
grouching1644943grouching
grouping12308533grouping
grousing103410453grousing
grouting103410793grouting
growing123512473gro_wing
growling1348163growling
grutching16224373grutching
hooting113919883hoot_ing
hotching17309313_hotching
hotting113116523_hotting
ironing82414013iro_ning
joshing18519413_joshing
jotting152912773_jotting
kithing153411553_kithing
knotting13236573knotting
kything18285523_kything
lathing114315693_lathing
loathing1247673loathing
looting83019643loot_ing
lotting82917753_lotting
mooching16259063mooching
mooting103019363moot_ing
morphing1637553morphing
moshing134214883_moshing
mouthing142810243mouthing
naething1236073naething
northings13185573northings
noshing114612773_noshing
notching14288583_notching
nothings12266683_nothings
noting74120153_not_ing
ohing96018813__o_hing
oohing104412933__oohing
orating83520323orat_ing
photoing1439073photoing
pithing134014053_pithing
plotting113011013plotting
plotzing20276153plotzing
pooching16328983pooching
poohing133112323_poohing
porting103021783port_ing
potting103720893_potting
prating103424453prat_ing
probing123314443pro_bing
prodding13189343prodding
progging132610383progging
promoing13310463promoing
pronging123511843pronging
proofing1439313proofing
propping122811673propping
prosing103319383pro_sing
protein92414733protein_
proteins102114283proteins
proving134214073pro_ving
prowling1449993prowling
quoting17310043quot_ing
rating74938703_rat_ing
ratting83822363_ratting
retching143412173_retching
rethink1488883_rethink
retting83425883_retting
retying113213833_retying
rioting82716393riot_ing
roaching143210433_roaching
roaming103215793_roaming
roaring82916003_roaring
robbing123313213_robbing
robing93618003_ro_bing
rocking143619633_rocking
rodding103814533_rodding
roguing9309563_roguing
roiling83220453_roiling
rolfing113710653_rolfing
rolling83620413_rolling
romping123113033_romping
roofing113814353_roofing
rooking123517363_rooking
rooming104117043_rooming
roosing84018133_roosing
rooting83522433_rooting
rootling9269953rootling
roping94023023_ro_ping
rosing73925593_ro_sing
rotating92614553_rotating
roughing13278343_roughing
rouging93114703_rouging
rouping103715793_rouping
rousing83920553_rousing
routing83821093_routing
roving103618743_ro_ving
rowing103623303_ro_wing
ruching133612933_ruching
rushing113817703_rushing
rutting82718043_rutting
scathing14269703scathing
scotching1735653scotching
scything17264883scything
seething1239023seething
shotting123012383shotting
sloshing12258823sloshing
slotting92612613slotting
smoothing1535293smoothing
sooting82820963soot_ing
sorting83221813sort_ing
southing122811823southing
spotting112812093spotting
stotting92811163stotting
swathing15248713swathing
swotting12268483swotting
teething1237163teething
thing96622983___thing
tithing113513893_tithing
tooting83019423toot_ing
tootling9279523tootling
torching142510083torching
toting74123793_tot_ing
totting82816843_totting
trashing122613223trashing
trithings13246603trithings
troaking133310973troaking
trocking153612423trocking
troking123514103tro_king
trolling93212493trolling
tromping13319603tromping
trooping112710283trooping
trophying1844713trophying
trotline8310023trotline
trouping11249503trouping
trowing113413703tro_wing
tything14316573_tything
voting103916033_vot_ing
vrooming14287353vrooming
withing143814493_withing
wooshing1536683wooshing
wotting112913843_wotting
wreathing16266313wreathing
writing113713893writ_ing
wronging13327393wronging

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.450397091.1
2DLD Change Limit1461623397.00320871.3
3Display Results3393390.1861822.6
 (SQL Overall)1786913397.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.