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

79 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
shealing12341546(None) 
healing113922961_healing
sealing83528561s_ealing
sheafing15329481sheafing
shealings13317561shealings
shearing123915901shearing
shearling1336921shearling
sheaving154110251sheaving
shelling123515211shelling
shoaling123111751shoaling
stealing93416601stealing
cheating144014522cheating
dealing94323232_dealing
haling104229782_h_aling
heading122919112_heading
heaping133015852_heaping
hearing113324162_hearing
heating114024322_heating
heaving144114762_heaving
heeling113618512_heeling
heiling113616362_heiling
helling114623222_helling
pealing104123202_pealing
scaling103519372s_caling
seaming103222112s_eaming
searing83330922s_earing
seating84130682s_eating
seedling102610952seedling
seeling83522002s_eeling
selling83225832s_elling
shading123115562sh_ading
shaking153317252sh_aking
shaming133016742sh_aming
shaping133116182sh_aping
sharing113723242sh_aring
shauling1249392shauling
shaving143414332sh_aving
shawing143514882sh_awing
shawling1558222shawling
shearings13337562shearings
shearlings1443532shearlings
sheathing1636872sheathing
shedding14278112shedding
sheening123010802sheening
sheering123715102sheering
sheeting122712832sheeting
shelving15278172shelving
shending132511252shending
shewing143812192she_wing
shieling123512402shieling
shilling123315382shilling
shooling123012562shooling
skoaling13227212skoaling
sleaving123310982sleaving
smearing113511752smearing
smelling113712722smelling
sneaking133211092sneaking
sneaping11349492sneaping
snelling93913562snelling
speaking153212492speaking
speaning113512242speaning
spearing113216102spearing
speeling112713122speeling
speiling113612972speiling
spelling113315232spelling
squealing1935152squealing
staling83925422s_taling
steading103613592steading
stealings10318852stealings
steaming114013212steaming
steeling93615142steeling
sterling93615552sterling
swearing123711442swearing
sweating123213022sweating
swelling123212752swelling
vealing114217422_vealing
whaling143910772wh_aling
wheeling15318592wheeling
yealing112716382_yealing

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 Filter1786911210590.393454684.5
2DLD Change Limit121059793.46634927.6
3Display Results79790.0332393.9
 (SQL Overall)178691793.89245912.4
 
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.