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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
pinna7532018(None) 
penna74520201penna
pina65842631pi_na
pinnae84414641pinnae
pinnal84814271pinnal
pinnas85315511pinnas
pinny105222061pinny
pinta75727051pinta
anna45529012_anna
canna75919332canna
donna66215032donna
finca104714502finca
finny114716752finny
ginny95314572ginny
henna84414042henna
hinny115616672hinny
inia45024692_inia
inn36727432_inn_
inns46920932_inns
jinn115420242jinn_
jinni125310632jinni
jinns126013842jinns
kina85631992ki_na
liana53915892liana
linga66820812linga
linn46034592linn_
linns56123332linns
manna75522532manna
mina65136902mi_na
minny104518662minny
ninja1258092ninja
ninny84514932ninny
panda85022612panda
panga85323532panga
panne76623652panne
pennae84314032pennae
penne75423852penne
penni74617902penni
pennia84412972pennia
penny105119452penny
pia56848032pi__a
pian66136092pian_
piano76118712piano
pians75126962pians
pica85831492pi_ca
pieta75421752pieta
piing85218832piing
pika106322952pi_ka
pilea75123952pilea
pima85428652pi_ma
pin57066722pi_n_
pinang92611592pinang
pinas75434452pinas
pinata83817212pinata
pinch125619302pinch
pine67755712pi_ne
pineal84817682pineal
pined85935322pined
pinene82915642pinene
pines76048862pines
pineta85815562pineta
piney105727502piney
ping75943592pi_ng
pingo87122712pingo
pings85830882pings
pining93726532pining
pink107039382pi_nk
pinko115618252pinko
pinks115729382pinks
pinky145823402pinky
pinnace113510312pinnace
pinnate93613742pinnate
pinned94818382pinned
pinner84521492pinner
pinnula934912pinnula
pinon76024532pinon
pinons86019942pinons
pinot78737292pinot
pins65558452pi_ns
pint66963172pi_nt
pintas85021392pintas
pinto75625752pinto
pints75936222pints
pinup9612882pinup
piny911838352pi_ny
pion67235292pion_
pions75826392pions
pirana8713262pirana
pirn67128372pirn_
pirns76020092pirns
pita65436432pi_ta
pitta75018692pitta
pizza1538182pizza
plena75816392plena
puna65331652p_una
punka114515482punka
punny104217712punny
senna54617982senna
sienna647192sienna
signa66114702signa
spinny114510182spinny
sunna55016062sunna
tinea54923152tinea
tinny85317652tinny
vina76331802vi_na
vinca105315162vinca
zinnia1536012zinnia

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001071.61033416.1
3Display Results1071070.0303566.7
 (SQL Overall)1786911071.733103110.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.