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

74 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
shieling12351240(None) 
shielding1434551shielding
shielings13237121shielings
shilling123315381shilling
spieling113212521spieling
chilling143512182chilling
chiseling1536402chiseling
chitling142910662chitling
heeling113618512_heeling
heiling113616362_heiling
hieing104216622_hie_ing
hilling113821772_hilling
hireling121210992_hireling
sailing83927372sai_ling
schilling15286392schilling
seeling83522002s_eeling
shauling1249392shauling
shaveling1646842shaveling
shawling1558222shawling
shealing123415462shealing
sheening123010802sheening
sheering123715102sheering
sheeting122712832sheeting
shelling123515212shelling
shelving15278172sh_elving
shewing143812192sh_ewing
shifting152910382shifting
shilingi1233842shi_lingi
shillings13348092shillings
shimming16278252shimming
shingling14136972shingling
shining113816522shi_ning
shinning123211022shinning
shipping163611252shipping
shirking163210472shirking
shirring122910442shirring
shirting123213612shirting
shitting123212662shitting
shivering1637332shivering
shoaling123111752shoaling
shoeing113211882shoe_ing
shooling123012562shooling
shoveling1635552shoveling
shrewing15228092shrewing
shrieking1734582shrieking
shrieving1633972shrieving
shrilling13307692shrilling
shriveling1743252shriveling
sibling10814422s_ibling
sideling101012182sideling
sidling9915422s_idling
sieging92613202s_ieging
sieving112311232s_ieving
skilling132911332skilling
skirling13249062skirling
smiling103915442smi_ling
sniveling1336032sniveling
soiling83422322soi_ling
speeling112713122speeling
speiling113612972speiling
spiering112713352spiering
spiling102919702spi_ling
spilling113113942spilling
steeling93615142steeling
stifling122110912stifling
stilling93415322stilling
swilling123511932swilling
swirling12249142swirling
swiveling1634572swiveling
thieving1535142thieving
thirling12248582thirling
wheeling15318592wheeling
whiling143511742whi_ling
whirling15237162whirling

Search took 5 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 Filter1786911210590.403443402.0
2DLD Change Limit121059744.06329795.5
3Display Results74740.0332242.4
 (SQL Overall)178691744.49939717.9
 
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.