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 “parsnip” 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
parsnip114632(None) 
parsnips1245531parsnips
palship1446832palship
parsing103819552parsing
parsonic1239702parsonic
warship1547832warship
airship1248513airship
arsenic939323_arsenic
arshin9312173_arshin
arsine64021043_arsine
arsino64113513_arsino
arsis55722423_ars_is
carnie84421093car_nie
catnip1097973ca_tnip
earlship1345103earlship
garni6315703gar_ni_
hardship1746033hardship
harelip1245953harelip
karstic1357983karstic
padroni10278613padroni_
paesani9348683paesani_
palships1546213palships
panic93923903pa__nic
panini8314273panini_
parang93715513paran_g
parangs104314373parangs
paranoia10410563paranoia
paranoic1249833paranoic
paranoid11311143paranoid
parasail1049233parasail
parboil1138323parboil
pardi85723953par_di_
pardie96021443par_die
pardine103616723pardine
pardner10239473pardner
parent83230423paren_t
parents93418123parents
paresis93315093paresis
paretic113016673paretic
parfait12312053parfait
parging113318603parging
paring94236493parin_g
parings104219213parings
paris75145943par__is
parking143423043parking
parling103823763parling
parodic122311723parodic
paronym1437503paronym
parosmia1245953parosmia
parotic112518043parotic
parotid102915513parotid
parring103222063parring
pars67560793pars___
parse75236993pars__e
parsec105914483pars_ec
parsecs11429923parsecs
parsed96323893pars_ed
parser84822373pars_er
parsers94118153parsers
parses85534703pars_es
parsley1247793parsley
parslied1137813parslied
parson83817903pars_on
parsonish1446323parsonish
parsons93516873parsons
parting103527383parting
partner92811393partner
parvis116114803par_vis
passim10410283pa_ssim
passing104318423passing
pastie85525523pa_stie
pastil85018323pa_stil
pastis84924323pa_stis
pausing103912813pausing
paynim1337363pa_ynim
pernio8513143per_nio
phrenic1438773phrenic
pogonip1245373pogonip
preship1439793preship
puranic11410483puranic
pursing103715553pursing
pursuit948273pursuit
sarsnet7314813sarsnet
snip66424653___snip
starship1348143starship
tarsi55222173tars_i_
tarsia65514273tars_ia
turnip836593tur_nip
wardship1744883wardship
warships1647553warships
worship1547833worship

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027915.90622693.4
3Display Results91910.0303033.3
 (SQL Overall)178691916.09229332.1
 
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.