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

91 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
pinniped134385(None) 
pinnipeds1441971pinnipeds
hinnied11348102hinni_ed
pinnated11338552pinnated
pinned94818382pinn__ed
pinnies93318442pinni_es
binned94414543binn__ed
cirriped1344183cirriped
connived1436433connived
dinned84317613dinn__ed
filliped1435223filliped
finned104114603finn__ed
finnier10319953finni_er
fissiped1444153fissiped
ginned83813983ginn__ed
ginnier8298983ginni_er
hinnies103615103hinni_es
ignited9137623_ignited
incised102911583_incised
incited103314623_incited
indited93515023_indited
infixed18206563_infixed
inned64118423_inn__ed
insipid1044513_insipid
invited113612463_invited
ionised82911493_ionised
ionized172611293_ionized
kidnaped1652163kidnaped
lionised946603lionised
lionized1837023lionized
milliped1337383milliped
minnies93617363minni_es
ninnies73713613ninni_es
pandied113913443pandi_ed
panned94123433pann__ed
pannier93613353panni_er
panniered1243853panniered
panpipe1034833panpipe_
panpipes1135173panpipes
pantiled113111593pantiled
penciled1337823penciled
pennated11299543pennated
penned94217613penn__ed
pennies94218813penni_es
pennine93712953pennine_
pennines103112043pennines
pennoned1136313pennoned
phonied133710563phoni_ed
picnicked2042813picnicked
pimped134913483pi__mped
pinched153812453pi_nched
pined85935323pi_n__ed
pinged104321383pi_n_ged
pinier84024693pi_ni_er
pinioned1137513pinioned
pinite8321243pi_nite_
pinites9319533pi_nites
pinked134819883pi_n_ked
pinkened1535753pinkened
pinkie124414273pinki_e_
pinkies133818263pinki_es
pinnace113510313pinnace_
pinnaces12268863pinnaces
pinnacled14304503pinnacled
pinnae84414643pinn_ae_
pinnate93613743pinnate_
pinner84521503pinn__er
pinning103417853pinni_ng
pinnule936003pinnule_
pinnules1036463pinnules
pintailed1245553pintailed
pintsized2153673pintsized
pinweed1346933pi_nweed
piped105123163p___iped
pipped104516543pi__pped
pitied94017253pi_ti_ed
plumiped1533313plumiped
ponied94920703p_oni_ed
principe1445683principe_
principled1742593principled
punned93416193punn__ed
punnier93511263punni_er
shinnied12345823shinni_ed
sinned73818413sinn__ed
sniped94913483__sniped
spinnies103210543spinni_es
tinned74317533tinn__ed
tinnier72910143tinni_er
whinnied15284153whinni_ed
winned104017013winn__ed
winnowed1543463winnowed

Search took 7 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.1561145455.1
2DLD Change Limit146162916.78021557.8
3Display Results91910.0303033.3
 (SQL Overall)178691916.96625651.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.