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

60 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
shrining122610851shrining
shining113816522sh_ining
shrinking1735652shrinking
shriving15268452shriving
brining103216473_brining
brinish1239963_brinish
chaining142810783chaining
chining133316843ch_ining
enshrining1464613enshrining
inshrining14104583inshrining
saining83621393s_aining
sardining1137573sardining
scribing13238183scribing
scriving14258763scriving
seining84020773s_eining
sericin9312843sericin_
sericins10312463sericins
sheening123010803sheening
shinier104113143sh_inier
shinily13268933sh_inily
shinning123211023shinning
shinny124810783sh_in_ny
shirking163210473shirking
shirring122910443shirring
shirting123213613shirting
shrewing15228093shrewing
shrewish1744743shrewish
shrieking1734583shrieking
shrieving1633973shrieving
shrilling13307693shrilling
shrimping1734063shrimping
shrine94920053shr__ine
shrined114112413shrin_ed
shrines104618693shrin_es
shrink134511733shr__ink
shrinker15236363shrinker
shrinks14397913shrin_ks
shriven13379653shriven_
shunning12367843shunning
skeining1347073skeining
soricine10710883soricine
sorning83116813sor_ning
splining11310773splining
spraining1248153spraining
springing1338743springing
sprinting12310033sprinting
staining9413373staining
straining10410563straining
striding102713603striding
striking133012233striking
stringing1139753stringing
striping112612523striping
striving122611393striving
swainish1444753swainish
swinish1347203s_winish
syringing1435883syringing
thriving15246353thriving
throning1238863throning
trining82919213_trining
whining143311673wh_ining

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.453394461.4
2DLD Change Limit146162606.92321112.5
3Display Results60600.0134615.4
 (SQL Overall)178691607.38924183.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.