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

191 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
stanching153808(None) 
starching1538591starching
staunching1643211staunching
blanching17297092blanching
branching17289262branching
cranching17278732cranching
ranching141712042_ranching
searching1538342searching
snatching1536362snatching
stacking154215082sta_cking
stanchion1444642stanchion
stanchions1543662stanchions
standing103413632stan_ding
stanging104013652stan_ging
staning83922242stan__ing
stashing123511582sta_shing
stitching1547102stitching
synching17227712s_ynching
aching126521973__a_ching
arching136216693__arching
attaching1545433attaching
baching156017753_ba_ching
batching163712093_batching
beaching164114143bea_ching
benching163411343_benching
blenching17276503blenching
brunching17316483brunching
bunching163410703_bunching
caching156317503_ca_ching
catching163712773_catching
chancing162810283chanc_ing
cinching163310223_cinching
clenching17266303clenching
clinching17276123clinching
coaching164011963coa_ching
craunching1843313craunching
crunching17297003crunching
dancing113611563_danc_ing
detaching1637263deta_ching
distancing1447083distanc_ing
drenching16256033drenching
etching134511843et__ching
fancying1735353_fancying
flenching18296703flenching
flinching18245833flinching
frenching18267753frenching
glancing1247063glanc_ing
glunching16174083glunching
hatching173312213_hatching
hunching17309113_hunching
inarching1546343inarching
inching134414323__inching
instancing1344643instanc_ing
itching134011683it__ching
lancing103314123_lanc_ing
latching143712023_latching
launching1544783launching
leaching143012833lea_ching
lunching143110003_lunching
lynching17336083_lynching
marching164312193_marching
matching163512393_matching
munching16299973_munching
parching164313053_parching
patching163212753_patching
peaching163613643pea_ching
pinching163711053_pinching
poaching163510833poa_ching
prancing132612163pranc_ing
punching163310123_punching
quenching2443923quenching
reaching143317203rea_ching
roaching143210433roa_ching
sacking144122703s_a_cking
sacring103115983s_a_cring
sanding93520603s_an_ding
sandling102214413s_andling
saning75127643s_an__ing
sashing114621473s_a_shing
saucing10311003s_auc_ing
scanning113310773scan_ning
scanting113914763scan_ting
scantling12107233scantling
scarphing1735243scarphing
scathing14269703sca_thing
sconcing1338263sconc_ing
scooching1735073scooching
scorching1735633scorching
scotching1735653scotching
scraiching1843793scraiching
scratching1844533scratching
scrunching18163473scrunching
scutching1735223scutching
shacking184014083sha_cking
shanking163612283shan_king
skanking12288743skan_king
sketching1935083sketching
slacking153914133sla_cking
slanging103413433slan_ging
slanting94115093slan_ting
slashing123713413sla_shing
slouching15195723slouching
smacking173510763sma_cking
smashing143310243sma_shing
smirching1744393smirching
smooching1734883smooching
smutching1734853smutching
snacking153411703sna_cking
snitching1535913snitching
spacing123614493spa_c_ing
spanceling1543943spanceling
spangling1336373spangling
spanking153911973span_king
spanning113311083span_ning
squinching2542973squinching
stabbing13238763sta_bbing
stabling112913653sta_bling
staffing15247493sta_ffing
stagging113310513sta_gging
staging93818373sta__ging
stagnating1254973stagnating
staining9413373sta_ining
staking123919803sta__king
staling83925423sta__ling
stalking133512223sta_lking
stalling95116703sta_lling
stamping133310963sta_mping
stanch113812373stanch___
stanched14208903stanch_ed
stancher13198813stanch_er
stanchers14206813stanchers
stanches132312793stanch_es
stanchest14218213stanchest
stanchioned1752233stanchioned
stanchioning1852143stanchioning
stanchly1644443stanch_ly
standings11257153stan_dings
stanine73417073stan__ine
stapling112813153sta_pling
starchier1436643starchier
starchily1745013starchily
staring84527053sta__ring
starling93017123sta_rling
starring92312953sta_rring
starting93116173sta_rting
startling1037373startling
starving122510173sta_rving
stating83725163sta__ting
staving113915703sta__ving
staying114017323sta__ying
stenchier1445333stenchier
stenciling1344173stenciling
sticking153513463st_icking
stinging103213453stin_ging
stinking133113543stin_king
stinting93415743stin_ting
stocking152912503st_ocking
stomaching1844313stomaching
stoning83717443ston__ing
stonishing1444913stonishing
stranding1149653stran_ding
strangling1256403strangling
stretching1645813stretching
stuccoing1442493stuccoing
stunning9298463stun_ning
stunting92811503stun_ting
swanking16399963swan_king
swanning12338813swan_ning
swashing15369743swa_shing
swathing15248713swa_thing
switching1835703switching
syncing13177223s_ync_ing
tacking144421483_ta_cking
talcing103111633_talc_ing
talcking1567083_talcking
tanging93419523_tan_ging
tangling101712543_tangling
tangoing10177893_tangoing
tanking123918793_tan_king
tanning83618253_tan_ning
teaching143612603_teaching
thatching1835143thatching
tincting1148883_tincting
torching142510083_torching
touching143211343_touching
trancing112812023tranc_ing
trenching15227653trenching
watching173011173_watching
wenching17328863_wenching
winching17359903_winching
wrenching18276273wrenching

Search took 7 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.436409841.7
2DLD Change Limit1486411916.39023261.5
3Display Results1911910.0802387.5
 (SQL Overall)1786911916.90625874.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.