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

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

97 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
sneering93414501sneering
sheering123715102sheering
sneerier878102sneerier
sneezing18267052sneezing
speering113116322speering
steering93916792steering
anearing9413973anearing
aneurin749843aneurin_
aneurins849073aneurins
angering102113803angering
anserine8313093anserine
cheering143612703cheering
entering91920053entering
fleering123811283fleering
inhering12913713inhering
jeering153513043_jeering
kneeing12226523knee_ing
kneeling13287783kneeling
leering83417643_leering
nearing83020333_nearing
needing93214423_needing
neurine7311683_neurine
peering103520353_peering
queering1838203queering
queerish2045313queerish
sabering112113743sabering
searing83330923s_earing
seeding93719483s_eeding
seeing74222143s_ee_ing
seeking124016063s_eeking
seeling83522003s_eeling
seeming103216263s_eeming
seeping103817913s_eeping
serein63318463s_erein_
sereins73716123s_ereins
serin55434443s__erin_
serine65432673s__erine
sering74731813s__ering
serins64029673s__erins
severing122013853severing
sewering122411093sewering
shearing123915903shearing
sheening123010803sheening
sheepish1645413sheepish
sheeting122712833sheeting
sintering101014803sintering
skeeing12308853skee_ing
skewering1744633skewering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
smearing113511753smearing
smeeking15317833smeeking
snaring83920953sn_aring
sneaking133211093sneaking
sneaping11349493sneaping
snedding11246953snedding
sneer54919953sneer___
sneered83113973sneer_ed
sneerer73512313sneer_er
sneerers8309803sneerers
sneerful1143553sneerful
sneeriest939313sneeriest
sneers64016173sneer__s
sneery93610413sneer__y
sneesh945893snee__sh
sneezier1774333sneezier
snelling93913563snelling
snoring83917203sn_oring
sobering111912783sobering
spearing113216103spearing
speeding122810933speeding
speeling112713123speeling
speerings12276843speerings
speiring113711263speiring
sphering142811943sphering
spiering112713353spiering
stearin7312003stearin_
stearine8311903stearine
stearins8312143stearins
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steepish1375823steepish
steeving12359653steeving
suberin9314563suberin_
suberins10315093suberins
sundering11312323sundering
supering11317683supering
swearing123711443swearing
sweeping14389143sweeping
sweeting123911313sweeting
sweetish1445373sweetish
unerring9311273unerring
veering113213683_veering
veneering1337663veneering

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162977.31319986.6
3Display Results97970.0303233.3
 (SQL Overall)178691977.76323018.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.