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

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

115 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
panpipe103483(None) 
panpipes1135171panpipes
bagpipe1453112bagpipe
pantie84326472panti_e
pantile93918482pantile
ranpike1335932ranpike
alpine84417373_alpine
anile54634463_an_ile
anime75423203_an_ime
anise55129703_an_ise
aspire8612123_aspire
bagpiped1642063bagpiped
bagpiper1542393bagpiper
bagpipes1543403bagpipes
canape10913513can_ape
canine83826703can_ine
cannie83819363canni_e
downpipe16313823downpipe
drainpipe1451673drainpipe
fanlike142610503fanlike
fanwise1336633fanwise
fanzine1937123fanzine
garpike1435093garpike
halfpipe1862443halfpipe
hankie133915713hanki_e
hornpipe1542763hornpipe
magpie1139093magpi_e
manciple1445093manciple
maniple11249653maniple
manlike133012783manlike
mannite9312903mannite
manrope1138033manrope
manwise1239183manwise
nannie63713223nanni_e
nappe96114993na_p_pe
nappie104112263nappi_e
paise75028333pa__ise
palpate113213923palpate
palpi95414553palpi__
palping124112873palping
panache1458423panache
pancake1536673pancake
pandied113913443pandied
pandies104224503pandies
pandit93820753pandi_t
pandits103914213pandits
pandore10411853pandore
pane64950283pan___e
panfish15229973panfish
pangene102711963pangene
panging113319113panging
panic93923903pan_i_c
panicle11129983panicle
panics103815363pan_ics
panier84425503pan_ier
panini8314273pan_ini
panino8315683pan_ino
panmixes1934913panmixes
panne76623653pan__ne
pannier93613353pannier
panning104019393panning
panoche1456383panoche
pansies94521983pansies
panties94230933panties
pantiled113111593pantiled
pantiles103617153pantiles
panting104025423panting
papism122211513pa_pism
papist102618743pa_pist
pappi84810893pa_p_pi
pappier103511593pappier
pappies103214823pappies
pappose1047413pappose
pappy114713803pa_p_py
papule102212133pa_pule
pardie96021443pardi_e
pardine103616723pardine
partite9317133partite
parvise124211693parvise
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
patine85328123pa_tine
pattie84020963patti_e
pavise114714803pa_vise
penile82219603pen_ile
penlite9313243penlite
pennine93712953pennine
pensile92713543pensile
pensive122610393pensive
pinite8321243pin_ite
pinkie124414273pinki_e
pinniped1343853pinniped
pipe86434433___pipe
pontine92419053pontine
potpie103412423potpi_e
praecipe1444633praecipe
precipe133012123precipe
preppie1058093preppie
principe1445683principe
propine113020213propine
punkie123513613punki_e
rampike1536603rampike
ranpikes1435643ranpikes
rapine85023083ra_pine
sandpile1146773sandpile
sandpiper14103523sandpiper
snipe75320573_sn_ipe
standpipe1443343standpipe
tailpipe1253003tailpipe
tawpie11339143tawpi_e
unpile81914323_unpile
unripe82012093_unripe
vampire14296673vampire
windpipe1643183windpipe

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271157.03319056.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.23524698.1
 
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.