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 “spicing” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
spicing12391453(None) 
slicing103514641slicing
spacing123614491spacing
spiking144312881spiking
spiling102919701spiling
spiring103918181spiring
spiting103917621spiting
splicing1338961splicing
aspiring1138872aspiring
deicing11312192deicing
dicing105718762_dicing
icing86017752__icing
juicing1736882juicing
opining10311742opining
pacing114522752_pacing
picking163418332_picking
piecing12410452_piecing
pieing93917652_pieing
piing85218832_pi_ing
piking133719642_piking
piling95025592_piling
pining93726532_pining
piping114017452_piping
pricing123417342pricing
ricing94822762_ricing
sailing83927372sailing
saining83621392saining
saucing10311002saucing
seining84020772seining
seising84018862seising
seizing174114832seizing
shining113816522shining
siccing12319512siccing
sicking143720172s_icking
siding83822132s_iding
siping94220632s_iping
sipping123117432sipping
siring75128312s_iring
siting74126622s_iting
sizing163616442s_izing
skiing113610192ski_ing
skiting123812502skiting
skiving15298372skiving
slicking153712592slicking
sliding93114552sliding
sliming102913952sliming
sliping103314412sliping
sluicing1137062sluicing
smiling103915442smiling
smiting103014442smiting
snicking153610232snicking
sniping103712052sniping
soiling83422322soiling
sopiting11310762sopiting
spacings13287042spacings
spading113114382spading
spaeing103413542spaeing
sparing104823872sparing
spaying133014622spaying
speccing15306642speccing
specking17359732specking
speiling113612972speiling
speiring113711262speiring
spewing133110452spewing
spicier115112462spicier
spicily1438652spicily
spieling113212522spieling
spiering112713352spiering
spiffing17237082spiffing
spilings11308812spilings
spilling113113942spilling
spinning113310812spinning
spirting112913632spirting
spitting113012322spitting
splining11310772splining
spoiling112911552spoiling
spoking143212222spoking
sporing104319412sporing
spring94526012sp_ring
sprucing1336892sprucing
spuing94313362sp_uing
spuming1248522spuming
spying123913252sp_ying
sticking153513462sticking
suiting83419002suiting
swiping13319822swiping
swiving14358952swiving
syncing13177222syncing
tricing103417352tricing
vicing124014242_vicing
voicing13279082voicing

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671913.37331921.4
3Display Results91910.0303033.3
 (SQL Overall)178691913.77947285.3
 
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.