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

188 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
panacea113779(None) 
panacean1244731panacean
panaceas1236771panaceas
palace104516922palace_
palaced124110782palaced
palaces114216462palaces
panache1458432panache
panaches15310292panaches
panada94113052pana_da
panama104213352pana_ma
panatela1044912panatela
panocha1444982panocha
pataca10311192patac_a
abaca95118043_abac_a
acacia10311353_acacia
anadem939183_anadem
anlace82513923_anlace_
anlaces92313733_anlaces
apace94718383_apace_
apanage1036803apanage_
apanages1137013apanages
apnea73413413apn__ea
apnoea867093apn_oea
azalea1537003_azalea
banana83213413bana_na
canaled103615563canaled
canape10913523canape_
canapes111213083canapes
canasta938363canasta
cancel105316683can_cel
cancer104220923can_cer
cancha134411613can_cha
dance85223133dan_ce_
danced105315253dan_ced
dancer94817613dan_cer
dances95120653dan_ces
galatea839973galatea
ganache1346223ganache
ganaches1437433ganaches
gynaecea1451293gynaecea
halacha15388023halacha
hanaper1237133hanaper
hance105424153han_ce_
hances115621283han_ces
kanaka9357523kana_ka
lanate6421263lanate_
lanated8313203lanated
lance75126723lan_ce_
lanced93717723lan_ced
lancer84319973lan_cer
lances84824103lan_ces
lancet84223573lan_cet
malacca1344963malacca
manacle11310283manacle
manacled1336453manacled
manacles1239523manacles
manage93818903manage_
managed113212603managed
manager103413583manager
manages103418963manages
manana84816073mana_na
manatee9317663manatee
maraca10314153marac_a
menace103216943menace_
menaced122710093menaced
menacer112610883menacer
menaces112715523menaces
nance74721843nan_ce_
nances83618643nan_ces
paca85132243p__ac_a
pace86345773p__ace_
paced106931683p__aced
pacer96131613p__acer
paces96741113p__aces
pacey126720283p__acey
pacha126518063p__acha
pajama17317653paja_ma
palabra1137193palabra
palapa10310673pala_pa
palate84226793palate_
palates93624943palates
palaver1238753palaver
palea75028663p__alea
panadas103312213panadas
panamas113112763panamas
panatelas1144113panatelas
panatella1143803panatella
pancake1536673pancake
pancaked1734893pancaked
pancakes1637073pancakes
pancetta1244653pan_cetta
panchax2134983pan_chax
pancreas1235403pancreas
panda85022613pan__da
pandect12310953pandect
pander93725533pan_der
pandied113913443pandied
pandies104224503pandies
pandora1039543pandora
pandura1037143pandura
pane64950293pan__e_
paned85437183pan__ed
panel76023623pan__el
paneled10612573paneled
panes76148693pan__es
panetela1044153panetela
panga85323543pan__ga
panged104722343pan_ged
pangen94115923pan_gen
panic93923903panic__
panicked1785173panicked
panicky1833853panicky
panicle11129983panicle
panicled13106783panicled
panicles121010133panicles
panics103815363panic_s
panicum1346393panicum
panier84425503pan_ier
panne76623653pan_ne_
panned94123433pan_ned
panner84224763pan_ner
pannes85522853pan_nes
pannier93613353pannier
panochas1545653panochas
panoche1456383panoche
panoches1548133panoches
pansies94521983pansies
pantalet10415903pantalet
panted95024823pan_ted
panther12611443panther
pantie84326473pantie_
panties94230933panties
panzer174213233pan_zer
papacies1439483papacies
papacy1547493papac_y
papaya1337503papa_ya
parade94720643parade_
paraded114014263paraded
parader103914863parader
parades104121473parades
parae76335713para_e_
paranoea1048583paranoea
parapet11317643parapet
parcel103915473pa_rcel
patacas11311003patacas
patagia1068783patagia
pavane114113443pavane_
pavanes123612663pavanes
pawnage1335873pawnage_
pawnages1435313pawnages
peace95026083p_eace_
peaced115818913p_eaced
peaces106324083p_eaces
penance11313443penance_
penanced1338163penanced
penances12312443penances
penates93321603penates
pence94924453pen_ce_
pencel103812923pen_cel
pinata83817223pina_ta
pincer104019173pin_cer
pinnace113510313pinnace_
pinnaces12268863pinnaces
place94824613p_lace_
placed114318003p_laced
placer105117743p_lacer
places104323703p_laces
placet103923673p_lacet
planaria1047353planaria
planate9314573planate_
pomace123111913pomace_
pomaces132712123pomaces
ponce95222513pon_ce_
ponced114314813pon_ced
ponces104720843pon_ces
prance104318573pran_ce_
pranced123714043pran_ced
prancer113613383pran_cer
prances113618783pran_ces
rance75028513ran_ce_
rances84625443ran_ces
rosacea944713rosacea
sancta839833san_cta
spancel1147363span_cel
tanager83010953tanager
tenace82715693tenace_
tenaces92814513tenaces
zanana153810363zana_na

Search took 9 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.423422437.4
2DLD Change Limit1340271887.59317651.4
3Display Results1881880.0603133.3
 (SQL Overall)1786911888.07622126.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.