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

186 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
starching153859(None) 
searching1538341searching
stanching1538081stanching
arching136216692__arching
inarching1546342inarching
marching164312192_marching
parching164313052_parching
scarphing1735242scarphing
scorching1735632scorching
smirching1744392smirching
snatching1536362snatching
stacking154215082sta_cking
starchier1436642starchier
starchily1745012starchily
staring84527052star__ing
starling93017122star_ling
starring92312952star_ring
starting93116172star_ting
startling1037372startling
starving122510172star_ving
stashing123511582sta_shing
staunching1643212staunching
stitching1547102stitching
torching142510082_torching
aching126521973__a_ching
archine125817053__archine
archings14499863__archings
arcing95819643__arc_ing
arcking145811963__arcking
attaching1545433attaching
baching156017753_ba_ching
batching163712093_batching
beaching164114143bea_ching
birching16328463_birching
blanching17297093blanching
branching17289263branching
caching156317503_ca_ching
catching163712773_catching
churching2055083churching
coaching164011963coa_ching
cranching17278733cranching
detaching1637263deta_ching
earthing12310333_earthing
etching134511843et__ching
farcing133514003_farc_ing
farthing1538073_farthing
hatching173312213_hatching
itching134011683it__ching
latching143712023_latching
leaching143012833lea_ching
lurching14277333_lurching
matching163512393_matching
outmarching1943603outmarching
patching163212753_patching
peaching163613643pea_ching
perching163711633_perching
poaching163510833poa_ching
ranching141712043_ranching
reaching143317203rea_ching
researching1743423researching
roaching143210433roa_ching
sacking144122703s_a_cking
sacring103115983s_a_cring
sarcina9310733s_arc_ina
sashing114621473s_a_shing
saucing10311003s_auc_ing
scarfing14309713scar_fing
scaring103421973scar__ing
scarping133312463scar_ping
scarring112511513scar_ring
scarting113415263scar_ting
scathing14269703sca_thing
scooching1735073scooching
scotching1735653scotching
scraiching1843793scraiching
scratching1844533scratching
scutching1735223scutching
searchingly2042843searchingly
searing83330923sear__ing
shacking184014083sha_cking
sharing113723243shar__ing
sharking163912973shar_king
sharping143011373shar_ping
sketching1935083sketching
slacking153914133sla_cking
slashing123713413sla_shing
slouching15195723slouching
smacking173510763sma_cking
smarting113212453smar_ting
smashing143310243sma_shing
smooching1734883smooching
smutching1734853smutching
snacking153411703sna_cking
snarfing12358663snar_fing
snaring83920953snar__ing
snarling92513183snar_ling
snitching1535913snitching
soaring83521893soar__ing
sourcing1158353sourc_ing
spacing123614493spa_c_ing
sparging122611133spar_ging
sparing104823873spar__ing
sparking152812543spar_king
sparkling16226353sparkling
sparling112714533spar_ling
sparring113112223spar_ring
stabbing13238763sta_bbing
stabling112913653sta_bling
staffing15247493sta_ffing
stagging113310513sta_gging
staging93818373sta__ging
staining9413373sta_ining
staking123919803sta__king
staling83925423sta__ling
stalking133512223sta_lking
stalling95116703sta_lling
stamping133310963sta_mping
stanchion1444643stanchion
stanchions1543663stanchions
standing103413633sta_nding
stanging104013653sta_nging
staning83922243sta__ning
stapling112813153sta_pling
starch113013203starch___
starched14199313starch_ed
starches131912913starch_es
starchiest1547193starchiest
starchiness1643943starchiness
starchy15286743starch__y
stargazing2193323stargazing
starlings10237923star_lings
starship1348143starshi_p
starships1447663starships
starveling1444263starveling
stating83725163sta__ting
staving113915703sta__ving
staying114017323sta__ying
stereoing1037893stereoing
sterling93615553ster_ling
sticking153513463st_icking
stirring9299653stir_ring
stocking152912503st_ocking
stomaching1844313stomaching
storing83921123stor__ing
storming11209423stor_ming
storying12249673stor_ying
strafing122111193st_rafing
straining10410563straining
stranding1149653stranding
straphang15113923straphang
straphung15112443straphung
strapping1436993strapping
strawing122411623st_rawing
straying122912693st_raying
stretching1645813stretching
strewing12289853st_rewing
striding102713603st_riding
striking133012233st_riking
string75327563st_r__ing
striping112612523st_riping
striving122611393st_riving
stroking132610943st_roking
strowing122310563st_rowing
stroying122410593st_roying
stuccoing1442493stuccoing
swarding1359003swar_ding
swarming1458223swar_ming
swashing15369743swa_shing
swathing15248713swa_thing
switching1835703switching
synching17227713s_ynching
tacking144421483_ta_cking
talcing103111633_talc_ing
talcking1567083_talcking
taring73932283_tar__ing
tarring83318303_tar_ring
tarrying12146723_tarrying
tarting84222653_tar_ting
teaching143612603_teaching
thatching1835143thatching
touching143211343_touching
trachling1537823_trachling
tracing103720153_trac_ing
tracking153715463_tracking
trashing122613223_trashing
watching173011173_watching

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.470380193.6
2DLD Change Limit1486411867.89018839.2
3Display Results1861860.0932000.0
 (SQL Overall)1786911868.45321139.4
 
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.