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

137 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
pampean133554(None) 
pampeans1444701pampeans
dampen114310592dampe_n
paean77222722pa__ean
pampa114913422pamp_a_
pampas124913992pamp_as
pamper124316662pampe_r
pampero13328092pampero
pampers133615932pampers
sampan102511892samp_an
tampan102512322tamp_an
ameban1039093_ameban
amebean1144853_amebean
amen66733153_am_e_n
amoeban1144913_amoeban
amped104820513_ampe_d
ampere10514413_ampere
apeak115513453_a_peak
apian75018333_a_pian
apogean1045443apogean
appeal103911613_appeal
appear10379343_appear
arpen74418043_arpe_n
aspen75216093_aspe_n
bemean10410683bem_ean
camped134720233campe_d
camper124722213campe_r
campers134220293campers
campion133011413campion
capelan1139003ca_pelan
captan101613343ca_ptan
daman84821163dam__an
damped124315583dampe_d
dampens12348563dampens
damper114117753dampe_r
dampers123915693dampers
dampest12411043dampest
demean9510563dem_ean
gamelan10106643gamelan
hamper134518653hampe_r
hampers143616953hampers
happen134812193happe_n
hempen1338963hempe_n
jambeau1843773jambeau
japan14411233ja_p_an
kamseen1344013kamseen
lactean956473lactean
lampad114510033lamp_ad
lampas106615953lamp_as
lamped114017543lampe_d
lampers113817333lampers
lampion11278303lampion
lampoon11267193lampoon
lumpen104010663lumpe_n
mean65538083__m_ean
nymphean1842403nymphean
packman1736693packman
paeans85118263pa__eans
paeon74819493pa__eon
paesan85114093pa_esan
pagan86121163pa__gan
pageant10312783pa_geant
paisan84417073pa_isan
palea75028663pa_lea_
paleae84820293pa_leae
paleal84716673pa_leal
palpal104112053palp_al
palped114513643palpe_d
pampered15229223pampered
pamperer14228333pamperer
pampering1638383pampering
pamperos14306693pamperos
panacean1244733panacean
pangen94115913pange_n
papa85827143pa_p_a_
papain10313793pa_pain
papal95820673pa_p_al
papas94927493pa_p_as
papaw125112493pa_p_aw
papayan1445303papayan
paper95128663pa_pe_r
papers105125323pa_pers
papery134812743pa_pery
paphian1437453paphian
parian83223963pa_rian
parmesan1244753parmesan
partan83820563pa_rtan
pastern94415063pastern
paten74827343pa_te_n
patten84418193patte_n
pattern93712053pattern
pauper103511943paupe_r
paupers114311073paupers
pavan106518473pa__van
pawpaw1653503pawp_aw
pean66147173___pean
pemican1348153pemican
pigpen1136583pigpe_n
pimped134913483pimpe_d
playpen1434693plaype_n
plumpen13276403plumpe_n
pompano1345203pomp_ano
pompon1238943pomp_on
preplan1149953preplan
priapean1243373priapean
propman1339063propman
protean92412193protean
pumped133915563pumpe_d
pumper124415553pumpe_r
pumpers133113673pumpers
pumpkin1743523pumpkin
pygmaean1651203pygmaean
pygmean1542223pygmean
ramen75625193ram_e_n
rampant11312173ramp_ant
ramped114617903rampe_d
rampion11298583rampion
rappen103512713rappe_n
salpian938493salpian
sampans112411003samp_ans
spalpeen1252503spalpeen
spean74620513__spean
taipan82410663taip_an
tamein8313093tam_ein
tampans113310983tamp_ans
tamped114317043tampe_d
tamper104618513tampe_r
tampers113516743tampers
tampion11298663tampion
tampon102911233tamp_on
tarpan82814293tarp_an
trappean1244393trappean
tympan13257013tymp_an
vamped144211013vampe_d
vamper134212653vampe_r
vampers143111623vampers
yamen104115183yam_e_n

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.190940478.9
2DLD Change Limit1340271376.50020619.5
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.73626527.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.