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

144 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
scorching173563(None) 
scooching1735071scooching
scotching1735651scotching
bescorching2142282bescorching
coaching164011962_coaching
couching163213262_couching
scarphing1735242scarphing
sconcing1338262sconc_ing
scootching1843362scootching
scorchingly2252062scorchingly
scoring103117212scor__ing
scorning1169132scor_ning
scrooching1843322scrooching
scutching1735222scutching
searching1538342searching
slouching15195722slouching
smirching1744392smirching
smooching1734882smooching
starching1538592starching
torching142510082_torching
arching136216693__arching
avouching1843273avouching
birching16328463_birching
blotching1734963blotching
botching16359703_botching
broaching17287663broaching
caching156317503_c_aching
catching163712773_catching
churching2055083churching
cinching163310223_cinching
circling1338423_circling
coacting133412703_coacting
cochin131313203_co_chin_
cochins141413103_co_chins
cocking163619983_co_cking
coercing1349003_coerc_ing
cording113620823_cor_ding
coring94433963_cor__ing
corking143018823_cor_king
corning103720123_cor_ning
coshing134316433_co_shing
couchings17285763_couchings
coughing15309213_coughing
crocking174313443_crocking
crouching1746383crouching
douching15349843_douching
escorting1237713escor_ting
forcing134013753_forc_ing
grouching1644943grouching
hoorahing1644913hoorahing
hotching17309313_hotching
inarching1546343inarching
lurching14277333_lurching
marching164312193_marching
mooching16259063_mooching
morphing1637553_morphing
mouching163110583_mouching
northing12199063_northing
notching14288583_notching
ouching134314903__ouching
parching164313053_parching
perching163711633_perching
poaching163510833_poaching
pooching16328983_pooching
pouching163210413_pouching
roaching143210433_roaching
scarfing14309713scar_fing
scaring103421973scar__ing
scarping133312463scar_ping
scarring112511513scar_ring
scarting113415263scar_ting
scathing14269703sc_athing
scoffing17275943sco_ffing
scolding12278913sco_lding
scooping133610633sco_oping
scooting113012643sco_oting
scoping123513823sco__ping
scorch13198093scorch___
scorched16187203scorch_ed
scorcher15196793scorch_er
scorchers16145513scorchers
scorches15189153scorch_es
scorifying1944473scorifying
scourging1334573scourging
scouring112810853sco_uring
scouting112612753sco_uting
scowing133812093sco__wing
scowling1458293sco_wling
scraiching1843793scraiching
scraping133310863sc_raping
scratching1844533scratching
screeching1843643screeching
screwing14288233sc_rewing
scribing13238183sc_ribing
scriving14258763sc_riving
scrolling12187803scrolling
scrooping1446593scrooping
scrootching1951893scrootching
scrouging1335263scrouging
scrunching18163473scrunching
scrying1338663sc_r_ying
scurrying15183833scurrying
scything17264883sc_ything
shocking184311543sho_cking
shoring112820073shor__ing
shorting122514803shor_ting
sketching1935083sketching
sloshing12258823slo_shing
sloughing14244753sloughing
smocking17349103smo_cking
smooshing1534793smooshing
smoothing1535293smoothing
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
snoring83917203snor__ing
snorting92613373snor_ting
socking143518603s_o_cking
soochong14104373s_oochong
soothing12269973s_oothing
sorbing102815263s_or_bing
soring74731883s_or__ing
sorning83116813s_or_ning
sorting83221813s_or_ting
souchong1484513s_ouchong
soughing13259733s_oughing
sourcing1158353sourc_ing
southing122811823s_outhing
splotching1842863splotching
sporing104319413spor__ing
sporting112415463spor_ting
stanching1538083stanching
stitching1547103stitching
stocking152912503sto_cking
stomaching1844313stomaching
storing83921123stor__ing
storming11209423stor_ming
storying12249673stor_ying
switching1835703switching
swooshing1643883swooshing
synching17227713s_ynching
touching143211343_touching
vouching17308233_vouching
worthing15178053_worthing

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411447.51619776.6
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.99922339.2
 
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.