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

160 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
panicked178517(None) 
panicled13106781panicled
anticked1538392_anticked
magicked1842962magicked
nicked135019682__nicked
packed154822602pa__cked
paiked135113432pa_i_ked
pancaked1734892pancaked
panickier1743172panickier
panicky1833852panick_y
panicle11129982panicle_
panicles121010112panicles
picked154421312p__icked
picnicked2042812picnicked
pricked164613832p_ricked
snicked143811632_snicked
aniseed839403_aniseed
arcked136211943_a_rcked
backed155725723ba__cked
banished14189063banished
banked135021443ban__ked
batiked1435963bati_ked
bricked164312063_bricked
clicked164112453_clicked
cricked164814283_cricked
danced105315253dan_c_ed
deticked1635693deticked
dicked144920863__dicked
fancied133310603fan_cied
flicked174610673_flicked
garlicked1772883garlicked
hacked164923513ha__cked
handpicked2351863handpicked
hanked144220603han__ked
havocked2142323havocked
hoicked1735963_hoicked
jacked204817523ja__cked
kicked124415943__kicked
knacked13287793_knacked
knocked13236303_knocked
lacked135324653la__cked
lanced93717723lan_c_ed
licked134621563__licked
mafficked2442243mafficked
manacled1336453manacled
manicured1443733manicured
mimicked1943253mimicked
monicker1635733monicker
musicked1734033musicked
necked134715063__necked
niched125514063__niched
nickel123811343__nickel
nicker123818703__nicker
nickled144010443__nickled
nocked134617383__nocked
paced106931683pa__c_ed
pacified1638363pacified
packer144223403pa__cker
packet144726503pa__cket
paddocked2042083paddocked
padlocked1942433padlocked
painches1588913painches
pained95622853pa_i_ned
painted104214633pa_inted
paired95017523pa_i_red
palaced124110783palac_ed
panacea1137793panac_ea
panache1458433panache_
panaches15310293panaches
pancake1536673pancake_
pancakes1637073pancakes
pandered121812573pandered
pandied113913443pan_died
paned85437183pan___ed
paneled10612573pan_eled
panelled1138963panelled
panfried14134933panfried
panged104722333pan__ged
panic93923903panic___
panickiest1843493panickiest
panicking1835293panicking
panics103815363panic__s
panicum1346393panic_um
panicums1444743panicums
panier84425503pani__er
panned94123433pan__ned
panniered1243853panniered
panoche1456383panoche_
panoches1548123panoches
panted95024823pan__ted
pantiled113111593pantiled
parbaked1735503parbaked
parched154013693pa_rched
parked134425143pa__rked
patched153514623pa_tched
patinaed11407833patinaed
patined105114783pati_ned
paunched1645523paunched
peacocked2042863peacocked
pecked155019103p__ecked
pedicled1436463pedicled
penciled1337823penciled
physicked2442113physicked
picker144422173p__icker
picket144924313p__icket
pickled164011883p__ickled
picnicker1942693picnicker
piked125623313p__i_ked
pinched153812453pin_ched
pinioned1137513pinioned
pinked134819883p__inked
pinpricked2151933pinpricked
planished1566123planished
planked143512283plan__ked
plinked143910893p_linked
plucked16367963p_lucked
pocked154818983p__ocked
policed123212233polic_ed
ponced114314813pon_c_ed
ponied94920703poni__ed
pranced123714043pran_c_ed
pranked143712093pran__ked
priced115018883p_ric_ed
pricker154013413p_ricker
pricket153616443p_ricket
prickled17358073p_rickled
prinked143412163p_rinked
pumiced1435173pumic_ed
punched153512173pun_ched
punished1436043punished
racked134526083ra__cked
ranched133113603ran_ched
ranked114620743ran__ked
ransacked1643843ransacked
ricked136523623__ricked
sacked135525213sa__cked
sanicle91210263sanicle_
sanicles10149943sanicles
sicked134524403__sicked
slicked144413843_slicked
snacked144013113_snacked
snicker133012673_snicker
spanked143111733span__ked
sticked144114633_sticked
tacked134723943ta__cked
talcked1446343ta_lcked
tanked113919293tan__ked
ticked134720523__ticked
tricked144016163_tricked
unlicked15248263unlicked
unpicked17237213unpicked
vandyked2041573vandyked
vanished15207743vanished
vanitied12138213vanitied
wanked144517153wan__ked
wicked164317413__wicked
wricked174910193_wricked
yacked164516793ya__cked
yanked144312243yan__ked
zincked2334233zin_cked

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621606.73321708.3
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.21924752.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.